Import from existing database (from sql file)

[Odonno]

Import/Scaffold a SurrealDB schema from an existing SQL file:

• BigQuery (untested)
• ClickHouse (untested)
• Hive (untested)
• MS SQL Server = partial support
  • Table definition
  • Column definition
  • Foreign keys (via record types)
  • Simple indexes
  • Unique indexes
  • Assertions
    • NOT NULL
    • Minlength/maxlength
  • Value
    • Default value
  • Extra features
    • Computed columns
    • Geometry types
• MySQL (untested)
• PostgreSql (untested)
• Redshift (untested)
• SQLite (untested)
• Snowflake (untested)

[scheung38]

@Odonno hello there, is this feature now allowing seamless migration from existing SQL Server in Azure to SurrealDB? Looking forward to using it.

[Odonno]

Hello Sebastian,

This is a preview feature and so, as of today, it only allows schema migration of a subset of the SQL Server language to SurrealDB.