I want to install the AWS Schema Conversion Tool (AWS SCT) and database drivers for Windows for my AWS Database Migration Service (AWS DMS) task.
Short description
The AWS SCT automatically converts the source database schema and most custom code to a format that's compatible with the target database. Any data that can't be converted is marked so that you can manually convert the data during your migration.
Resolution
Install the AWS SCT
Note: These steps are for Windows OS to install the AWS SCT.
- Download the zip file.
Example: aws-schema-conversion-tool-1.0.latest.
- Extract the AWS Schema Conversion Tool .msi file.
Example: AWS Schema Conversion Tool-build-number.msi.
- Open the folder.
- Run the AWS SCT installer file.
Install the database driver
Note: These install the database drivers for an environment that runs MySQL with a Java Database Connectivity (JDBC) driver for Windows.
- Download the connector from your database engine's documentation. For more information, see Downloading the required database drivers.
- Select JDBC Driver for MySQL, and then choose Download.
- Download the platform-independent (architecture-independent) ZIP archive or TAR archive.
- Unzip the file
Example: mysql-connector-java-5.1.42.
- Create a directory, and then move the files to the new directory
Example: C:\java-5-1-42.
- Note the file location.
Set the driver location globally in the AWS SCT
- Open the AWS SCT, and then from Settings, choose Global Settings.
- Choose Drivers.
- In the MySql Driver Path, choose Browse.
- Go to the location of your driver that you noted.
Example: C:\java-5-1-42.
- Open the folder and choose the executable jar file.
Example: mysql-connector-java-5.1.42-bin.
- Choose OK.
Related information
What Is the AWS Schema Conversion Tool?
Installing, verifying, and updating AWS SCT
Using the AWS SCT user interface
Migration strategy for relational databases