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.
Hi, I think you may encounter some issues with pgloader as it makes use of a specific feature in PostgreSQL, but if you are considering moving data from MSSQL to CrateDB you may find this tutorial interesting and you could use this to get started translating MSSQL statements (including CREATE TABLE
commands) to the PostgreSQL dialect.