Wondering how to convert Database Schema AWS DMS task? We can help you.

For the AWS DMS task, we need to install the AWS Schema Conversion Tool and database drivers for Windows.

Here, at Bobcares, we assist our customers with several AWS queries as part of our AWS Support Services.

Today, let us see how to perform that.

Convert Database Schema AWS DMS task

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 convert the data manually during your migration.

Moving ahead, let us see the steps our Support Techs follow to perform the query.

• Install the AWS SCT

Before we proceed, make note that these steps are for Windows OS.

1. Initially, we download the zip folder.
2. Then we extract the AWS Schema Conversion Tool .msi file.
3. After that, we open the folder.
4. Finally, we run the AWS SCT installer file.

• Install the database driver

These steps install the database drivers for an environment that runs MySQL with a Java Database Connectivity (JDBC) driver for Windows.

1. We download the connector from the database engine’s documentation.
2. Then we select JDBC Driver for MySQL > Download.
3. We download the platform-independent (architecture-independent) ZIP archive or TAR archive.
4. After that, we unzip the file
5. Later we create a directory, and then move the files to the new directory.
6. We also note or copy that file location.

• Set the driver location globally in the AWS SCT

1. Open the AWS SCT, and then we go to Settings > Global Settings.
2. Here, we select Drivers.
3. Then in the MySql Driver Path, we select Browse.
4. We go to the location of the driver that we previously noted.
5. Eventually, we open the folder and select the executable jar file.
6. Finally, we select OK.

[Stuck in between? We are here for you]

Conclusion

To conclude, here we saw how our Support Techs install the AWS Schema Conversion Tool and database drivers.