Links

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.
All the source code for these scripts is open source and is available on GitHub.

Prerequisites

  • 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.

Installing the scripts

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
Follow the Usage Instructions to modify the files and run them on your system.
The script will create an output folder. A log will be created with the tool's progress.

Package the results

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