Overview
After switching to DWS databases, you may need to migrate user data and application SQL scripts to new databases. In particular, the migration of application SQL scripts is complex, risky, and time-consuming.
DSC is a CLI tool running on Linux or Windows. It is dedicated to providing customers with simple, fast, and reliable application SQL script migration services. It parses the SQL scripts of source database applications using the built-in syntax migration logic, and converts them to SQL scripts applicable to 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.
The syntax parser built in DSC can identify only standard SQL syntax. If the input script contains texts in other languages, syntax parsing will fail. You need to clean such input script before using DSC.
Migration Objects
DSC supports migration of Teradata, MySQL, SQL-Server, Oracle, Netezza, and Greenplum databases. For details, see Table 1. The following database objects can be migrated:
- DDL statements: schemas, tables, views, stored procedures, and user-defined functions
- DML statements: SELECT, UPDATE, DELETE, INSERT, and TRUNCATE
Migration Process
The process of using DSC to migrate SQL scripts is as follows:
- Export the SQL scripts from the source database to the Linux or Windows server installed with DSC.
- Execute DSC to migrate the syntax. In the command, specify the paths of the input file, output file, and logs.
- DSC automatically archives the migrated SQL scripts and the logs into the specified paths.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
