How can I improve the performance of the AWS SCT conversion tool when I use AWS DMS?

1 minute read
0

The AWS Schema Conversion Tool (AWS SCT) takes longer than expected to convert source database objects to a format that’s compatible with my target AWS Database Migration Service (AWS DMS) database.

Resolution

AWS SCT performance depends on the memory that's available to it on the local machine where it's installed. To improve performance, increase the memory available to AWS SCT.

For steps to configure the amount of memory available to AWS SCT, see Configuring additional memory.

Note: It's a best practice to install the AWS SCT on a separate machine that's in the same network as your source. This allows for better performance in the code conversion and data migration phases. To avoid performance issues in the data warehouse migration, make sure that the source database stats are current.

Related information

How do I increase logging levels for the AWS SCT when using AWS DMS?

How do I install the AWS SCT and database drivers for Windows to convert the database schema for my AWS DMS task?

AWS OFFICIAL
AWS OFFICIALUpdated a month ago