Help Center > > Developer Guide> Data Import> Using the DSC Tool to Migrate SQL Scripts

Using the DSC Tool to Migrate SQL Scripts

Updated at: Jul 15, 2020 GMT+08:00

The Database Schema Convertor (DSC) 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 of source database applications by using the built-in syntax migration logic, and migrates them to be applicable to DWS databases. You do not need to connect the DSC to a database. It can migrate data in offline mode without service interruption. In DWS, you can run the migrated SQL scripts to restore the database, thereby easily migrating offline databases to the cloud.

The DSC can migrate SQL scripts of Teradata, Oracle, Netezza, MySQL, and DB2 databases.

Downloading the DSC SQL Migration Tool

  1. Log in to the DWS management console.
  2. In the navigation tree on the left, click Connection Management.
  3. In the Download Client and Driver area, click here to download the DSC migration tool.

    If you have clusters of different versions, the system displays a dialog box, prompting you to select the cluster version and download the client corresponding to the cluster version. In the cluster list on the Cluster Management page, click the name of the specified cluster and click the Basic Information tab to view the cluster version.

    Figure 1 Downloading the tool

Operation Guide for the DSC SQL Migration Tool

For details, see DSC - SQL Syntax Migration Tool.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel