MS SQL server to CrateDB convert

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.

1 Like