Migrate the data of a SQL Server database to a database on an ApsaraDB RDS for PostgreSQL instance with Babelfish enabled - ApsaraDB RDS

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.

Prerequisites

An ApsaraDB RDS for PostgreSQL instance for which Babelfish is enabled is created. For more information, see Enable Babelfish for an ApsaraDB RDS for PostgreSQL instance.
A Babelfish account is created. For more information, see Create a Babelfish account to connect to an ApsaraDB RDS for PostgreSQL instance with Babelfish enabled.
A whitelist is configured to allow the server on which your client resides to access the RDS instance. For more information, see Configure an IP address whitelist for an ApsaraDB RDS for PostgreSQL instance.
The endpoints and Tabular Data Stream (TDS) port of the RDS instance are obtained. For more information, see View the endpoints and TDS port.

Procedure

Export the table objects and data of the SQL Server database.
1. 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).
2. In the left-side navigation pane of Object Explorer, right-click the SQL Server database that you want to migrate. Then, choose Tasks > Generate Scripts.
3. In the Generate Scripts configuration wizard, configure the parameters and export the script to a .sql file.
  1. Click Next in the Introduction step.
  2. In the Choose Objects step, select Script entire database and all database objects and click Next.
  3. 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.
  4. In the Summary step, click Next.
  5. 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.

Note For more information about Babelfish Compass, see Babelfish Compass official documentation.
Execute the modified T-SQL statements on the RDS instance for which Babelfish is enabled.
1. 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.
2. Execute the modified T-SQL statements on the RDS instance.