SQLMDX - MS SQL Migrate - Local Client Code
There are several scripts provided for you to execute locally to migrate the database schema metadata from your target to the source.
Github Repository
Link To MSSQLtoSnowflake
Pull Then Push
mssql_pull_then_push.py
The script mssql_pull_then_push.py contains all the steps required to pull
metadata from a database in your MSSQL Instance and then push that metadata
to Snowflake.
The code is documented. You don't have to understand all the steps but shouldn't
execute something that is complely foreign. All you need to do is download the file,
change the credentials shown in the next step, set the target database, execute it.
The script mssql_pull_only.py contains all the steps required to pull
metadata from a database in your MSSQL Instance.
The code is documented. You don't have to understand all the steps but shouldn't execute something that is complely foreign. All you need to do is download the file, change the credentials shown in the next step, set the target database, execute it.
The code is documented. You don't have to understand all the steps but shouldn't execute something that is complely foreign. All you need to do is download the file, change the credentials shown in the next step, set the target database, execute it.
The script mssql_push_only.py contains all the steps required to pull
metadata from a database in your MSSQL Instance.
The code is documented. You don't have to understand all the steps but shouldn't execute something that is complely foreign. All you need to do is download the file, change the credentials shown in the next step, set the target database, execute it.
The code is documented. You don't have to understand all the steps but shouldn't execute something that is complely foreign. All you need to do is download the file, change the credentials shown in the next step, set the target database, execute it.
Create Snowflake Objects
mssql_create_snowobjects.sql
The script mssql_create_snowobjects.sql contains
the sql script to be executed in Snowflake to move the schemas/tables/views to the
database of your choice. Snowflake security does not allow you direct access to
the objects created by the Native Application. You need this to create full
materialized objects that your role owns.