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

Procedure

  1. 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. 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. Choose Objects
      3. In the Set Scripting Options step, select Save as script file and configure the File name parameter. Then, click Next. Set Scripting Options
        • 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: Export DDL statements
        • 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. Export DML statements
      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.

  2. 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.
  3. 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.