Transact-SQL Conversion Settings

Applies to

• SQL Server

• Azure Synapse Analytics

General Conversion Settings

General Conversion Settings page

1. Comment objects with missing dependencies: Flag to indicate if the user wants to comment on nodes that have missing dependencies.

2. Set encoding of the input files: Check General Conversion Settings for more details.

To review the Settings that apply to all supported languages, go to the following article.

DB Objects Names Settings

DB Objects Names Settings page

1. Schema: The string value specifies the custom schema name to apply. If not specified, the original database name will be used. Example: DB1.myCustomSchema.Table1.

2. Database: The string value specifies the custom database name to apply. Example: MyCustomDB.PUBLIC.Table1.

3. Default: None of the above settings will be used in the object names.

Prepare Code Settings

Prepare Code Settings page

1. Prepare my code: This flag indicates whether or not to preprocess or arrange the source code before its transformation. By default, it's set to FALSE.

You can read the entire arrange documentation in the arrange documentation page

Stored Procedures Target Languages Settings

Stored Procedures Target Languages Settings page

On this page, you can choose whether stored procedures are migrated to JavaScript embedded in Snow SQL, or to Snowflake Scripting. The default option is Snowflake Scripting.

Reset Settings: The reset settings option appears on every page. If you've made changes, you can reset SnowConvert to its original default settings.