This topic describes how to migrate table objects and data of a SQL Server database
to a database on an ApsaraDB RDS for PostgreSQL instance for which Babelfish is enabled.
Procedure
- Export the table objects and data of the SQL Server database.
- Connect to the SQL Server database by using SQL Server Management Studio (SSMS). For
more information, see Quickstart: Connect and query a SQL Server instance using SQL Server Management Studio
(SSMS).
- In the left-side navigation pane of Object Explorer, right-click the SQL Server database that you want to migrate. Then, choose .

- In the Generate Scripts configuration wizard, configure the parameters and export the script to a
.sql
file.
- Click Next in the Introduction step.
- In the Choose Objects step, select Script entire database and all database objects and click Next.

- In the Set Scripting Options step, select Save as script file and configure the File name parameter. Then, click Next.

- If you want to export the data definition language (DDL) statements of the SQL Server
database, perform the following operations: In the Set Scripting Options step, click
Advanced. In the Advanced Scripting Options dialog box, configure the parameters based on
the following figure:

- If you want to export the data manipulation language (DML) statements of the SQL Server
database, perform the following operations: In the Set Scripting Options step, click
Advanced. In the Advanced Scripting Options dialog box, set Type of data to script to Data only.

- In the Summary step, click Next.
- In the Save Scripts step, click Confirm.
After the configuration, you can obtain the .sql
file from the path that you specified in the Set Scripting Options step.
- Run Babelfish Compass to check how Babelfish supports T-SQL statements and make required
modifications based on the results.
- Execute the modified T-SQL statements on the RDS instance for which Babelfish is enabled.
- Connect to the RDS instance over the TDS port. For more information, see Use clients to connect to an ApsaraDB RDS for PostgreSQL instance with Babelfish enabled.
- Execute the modified T-SQL statements on the RDS instance.