SnowConvert AI - SQL Server Conversion Settings

Applies to

  • SQL Server

  • Azure Synapse Analytics

常规转换设置

“General Conversion Settings”页面

  1. 注释缺失依赖项的对象： 该标志用于指示用户是否想要注释缺少依赖项的节点。

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

备注

要查看适用于所有支持语言的设置，请前往以下 文章。

DB 对象名称设置

“DB Objects Names Settings”页面

  1. 架构： 字符串值指定要应用的自定义架构名称。如果未指定，则将使用原始数据库名称。示例：DB1.myCustomSchema.Table1.

  2. 数据库： 字符串值指定要应用的自定义数据库名称。示例：MyCustomDB.PUBLIC.Table1.

  3. 默认值： 对象名称中将不使用上述任何设置。

准备代码设置

“Prepare Code Settings”页面

Description

Prepare my code: Flag to indicate whether the input code should be processed before parsing and transformation. This can be useful to improve the parsing process. By default, it's set to FALSE.

Splits the input code top-level objects into multiple files. The containing folders would be organized as follows:

Copy

└───A new folder named ''[input_folder_name]_Processed''
    └───Top-level object type
        └───Schema name
Copy

Example

Input

├───in
│       script_name.sql
Copy

Output

Assume that the name of the files is the name of the top-level objects in the input files.


├───in_Processed
    ├───procedure
    │   └───dbo
    │           A_PROCEDURE.sql
    │           ANOTHER_PROCEDURE.sql
    │           YET_ANOTHER_PROCEDURE.sql
    │
    └───table
        └───dbo
                MY_TABLE.sql
                ADDITIONAL_TABLE.sql
                THIRD_TABLE.sql
Copy

Requirements

We highly recommend using SQL Server Management Studio (SSMS) (https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16) to obtain the script.

存储过程目标语言设置

“Stored Procedures Target Languages Settings”页面

在此页上，您可以选择是将存储过程迁移到嵌入 Snow SQL 中的 JavaScript，还是迁移到 Snowflake Scripting。默认选项是 Snowflake Scripting。

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

语言: 中文