MS SQL server to CrateDB convert

[Shakeel_Ahmed]

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.

[proddata]

how big/complex are your schemas?

The available data types are listed here:

Data definition

CrateDB schemas are very similar to PostgreSQL schemas.

[Emre_Sevinc]

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.