• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Data Import
  5. Using the Migration Tool to Migrate the Teradata/Oracle Scripts to DWS

Using the Migration Tool to Migrate the Teradata/Oracle Scripts to DWS

The Migration Tool is used to migrate the SQL scripts of the Teradata or Oracle databases to the SQL scripts applicable to DWS so that DWS can restore the databases by running the SQL scripts to easily migrate the offline databases to the cloud.

It is a command line tool running on the Linux OS. You can download and use it without installation.

Downloading Migration Tool

  1. Log in to the management console at https://console.otc.t-systems.com/dws/.
  2. In the navigation tree on the left, click Connection Management.
  3. In the Download Client and Driver area, click here to download the Migration Tool.

    Figure 1 Downloading Migration Tool

  4. After downloading the Migration Tool to the local PC, use WinSCP to upload it to a Linux host.

    The user who uploads the tool must have the full control permission on the target directory of the Linux host.

Using the Migration Tool to Migrate the Teradata/Oracle Scripts to DWS

For details, see "Migration Tool - SQL Syntax Migration Tool" in the Data Warehouse Service Tool Guide.