Code Extraction
Instructions to extract SQL Server code.
The first step for migration is getting the code that you need to migrate. There are many ways to extract the code from your database. However, we recommend using the extraction scripts provided by Snowflake.
- These scripts must be run in Windows.
- Access to a server with an SQLServer database.
- Permission to run Powershell scripts with access to the server.
Download SC.DDLExportScripts
From the Code option, select the drop-down and use the Download ZIP option to download the code.
Decompress the ZIP file. The code for SQL Server should be under the SQL Server folder
The script will create an output folder. A log will be created with the tool's progress.
When the extraction process is finished. Compress the results and send them over: You can use the Windows File Explorer or from the command line run:
compact /c /s "output" /I /Q