Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> Overview
View PDF

Overview

After switching to GaussDB(DWS) databases, you may need to perform migration. Database migration includes user data migration and SQL script migration of applications. The latter one is a complex, risky, and time-consuming process.

DSC (Database Schema Convertor) is a command line tool running on Linux or Windows. It is designed to provide simple, fast, and reliable SQL script migration of applications. DSC parses the SQL scripts of source database applications through its syntax migration logic and migrates the scripts to the ones applicable to GaussDB T, GaussDB A, and GaussDB(DWS) databases.

DSC does not require a connection to databases, and performs migration offline. The tool also displays the status of a migration process and logs the errors that occur during the process, helping quickly locate faults.

Migration Objects

DSC can migrate the following Teradata, Oracle,Netezza, MySQL, and DB2 database objects:

  • General objects: SQL schemas and SQL queries
  • Objects supported only by Oracle and Netezza: PL/SQL objects
  • Objects supported only by Teradata: Perl files containing BTEQ and SQL_LANG scripts

Migration Process

The process of migrating SQL scripts by using DSC is as follows:

  1. Export the SQL scripts from a Teradata or Oracle database to the Linux or Windows server installed with DSC.
  2. Execute DSC to migrate the syntax. In the command, specify the paths of the input file, output file, and logs.
  3. DSC automatically archives the migrated SQL scripts and the logs into the specified paths.
Figure 1 DSC Process