Menu
AWS Database Migration Service
Step-by-Step Migration Guide (API Version 2016-01-01)

Step 2: Install the SQL Tools and AWS Schema Conversion Tool on Your Local Computer

Next, you need to install a SQL client and AWS SCT on your local computer.

This walkthrough assumes you will use the SQL Workbench/J client to connect to the RDS instances for migration validation.

To install the SQL client software

  1. Download SQL Workbench/J from the SQL Workbench/J website, and then install it on your local computer. This SQL client is free, open-source, and DBMS-independent.

  2. Download the Oracle Database 12.1.0.2 JDBC driver (ojdbc7.jar).

  3. Download the Amazon Redshift driver (RedshiftJDBC41-1.1.17.1017.jar).

  4. Using SQL Workbench/J, configure JDBC drivers for Oracle and Amazon Redshift to set up connectivity, as described following.

    1. In SQL Workbench/J, choose File, then choose Manage Drivers.

    2. From the list of drivers, choose Oracle.

    3. Choose the Open icon, then choose the ojdbc.jar file that you downloaded in the previous step. Choose OK.

      
                                         AWS Database Migration Service driver management
    4. From the list of drivers, choose Redshift.

    5. Choose the Open icon, then choose the Amazon Redshift JDBC driver that you downloaded in the previous step. Choose OK.

      
                                         AWS Database Migration Service driver management

Next, install AWS SCT and the required JDBC drivers.

To install AWS SCT and the required JDBC drivers

  1. Download AWS SCT from Installing and Updating the AWS Schema Conversion Tool in the AWS Schema Conversion Tool User Guide.

  2. Follow the instructions to install AWS SCT. By default, the tool is installed in the C:\Program Files\AWS Schema Conversion Tool\AWS directory.

  3. Launch AWS SCT.

  4. In AWS SCT, choose Global Settings from Settings.

  5. Choose Settings, Global Settings, then choose Drivers, and then choose Browse for Oracle Driver Path. Locate the Oracle JDBC driver and choose OK.

  6. Choose Browse for Amazon Redshift Driver Path. Locate the Amazon Redshift JDBC driver and choose OK. Choose OK to close the dialog box.

    
                                Connecting to the Oracle DB instance for AWS Database Migration Service