Migrating a Microsoft SQL Server Database to TaurusDB for PostgreSQL Using Babelfish

Scenarios

This section describes how to migrate a Microsoft SQL Server database to TaurusDB for PostgreSQL. Babelfish's compatibility with Microsoft SQL Server helps minimize the need for code adaptation, streamline the migration process, improve efficiency, and save resources.

Prerequisites

You have deployed a TaurusDB for PostgreSQL instance with Babelfish enabled.
You have created a Babelfish account.
You have configured an IP address whitelist to allow the server where the client is located to access the target instance.
You have installed a Microsoft SQL Server client tool (for example, sqlcmd).
You have enabled Huawei Cloud Data Replication Service (DRS) if you plan to migrate data using it.

Procedure

Step 1: Export Objects and Data of a Microsoft SQL Server Database

Connect to the Microsoft SQL Server database.
1. Use SSMS to connect to the destination database.
2. In the Object Explorer window, right-click the destination database and choose Tasks > Generate Scripts....
Generate a script.
1. Introduction: Click Next.
2. Choose Objects: Select Script entire database and all database objects and click Next.
3. Set Scripting Options:
  1. Select Save as script file and specify the output file name.
  2. To export the data definition language (DDL) script, click Advanced and enable the corresponding configuration.
  3. To export the data manipulation language (DML) script, click Advanced and set Types of data to script to Data only.
Obtain the exported SQL file.
After the script is generated, obtain the exported .sql file from the preset path.

Step 2: Use Babelfish Compass to Evaluate Compatibility

Run Babelfish Compass to analyze the support for T-SQL statements in Babelfish and optimize the statements.

Note: For details about how to obtain and use the tool, see the Babelfish Compass official documentation.

Step 3: Import the DDL Script to the Babelfish Database

Connect to the TDS port of the Babelfish instance.
For details, see Connecting to a TaurusDB for PostgreSQL Instance Through sqlcmd.
Execute the DDL script.
```
:r /path/to/your_ddl_script.sql
GO
```