We are planning to sync MS SQL Database to CrateDB. Could you please guide what is the best way to convert the schema of MS SQL to crateDB.
how big/complex are your schemas?
The available data types are listed here:
CrateDB schemas are very similar to PostgreSQL schemas.
You might want to give https://pgloader.io/ a try. According to its documentation, one of the supported options is indicated as “Migrate from MS SQL Server® to PostgreSQL”. And since CrateDB is mostly compatible with PostgreSQL, PgLoader might be able to satisfy your requirements.