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.
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.