Updated on 2023-03-30 GMT+08:00

Database Schema Convertor

Background

After customers switch to Huawei databases, database migration is required, which includes user data migration and application SQL script migration.

The migration of application SQL scripts is a complex, risky, and time-consuming process.

Description

Database Schema Convertor is a command-line tool running on the Linux or Windows OS. It is dedicated to providing customers with simple, fast, reliable application SQL script migration services. It parses SQL scripts into ones that compatible with GaussDB(DWS).

Database Schema Convertor does not require a connection to databases, and can perform 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.

Database Schema Convertor supports migration from Teradata and Oracle to GaussDB(DWS). It now supports the following objects:

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

Target user groups

  • Database administrators
  • Database migration engineers

Technical Principles

Figure 1 Database Schema Convertor architecture

Database Schema Convertor supports the following types of source and target databases:

No.

Function

Description

1

Teradata Perl Migration

Migrating Teradata Perl files to GaussDB A, GaussDB 300, and GaussDB(DWS)

2

Teradata SQL Migration

Migrating Teradata SQL to GaussDB A, GaussDB 300, and GaussDB(DWS)

3

Oracle SQL Migration

Migrating Oracle SQL to GaussDB A, GaussDB 300, and GaussDB(DWS)

4

Oracle(beta) SQL Migration

Migrating Oracle SQL to GaussDB A, GaussDB 300, and GaussDB(DWS)

For details about how to use Database Schema Convertor, see the section DSC: SQL Syntax Migration Tool.