SQLMDX - MS SQL Migrate - Native App Versions
There are 3 different versions of the Snowflake Native App - MS SQL Migrate.
FREE Version - Execute to show solution is working in your environment.
STANDARD Version - Basic Tables Only
EXTENDED Version - Tables, Views, Column Specifics
CALL _CODE.MSSQL_MIGRATE_FREE( ... );
FREE Version
- all schemas defined
- all tables basic structure
- all columns defined as int
- all columns nullable
- no column default values
- no column identity values
- no views
- no primary keys
- no foreign keys
CALL _CODE.MSSQL_MIGRATE( ... );
STANDARD Version
- all schemas defined
- all tables defined
- all columns datatypes converted to snowflake types
- all columns nullability matches source
- all columns default values defined
- all columns identity values defined
- no views
- no primary keys
- no foreign keys
CALL _CODE.MSSQL_MIGRATE_EXTENDED( ... );
EXTENDED Version
- all schemas defined
- all tables defined
- all columns datatypes converted to snowflake types
- all columns nullability matches source
- all columns default values defined
- all columns identity values defined
- normal views defined (see below)
- optional normal views as tables
- primary keys defined
- foreign keys defined