AWS DMS best practices for moving large tables with table parallelism settings
Database Blog
The article discusses AWS Database Migration Service (AWS DMS) best practices for migrating large tables using table parallelism settings. It highlights different parallelism options available in AWS DMS and provides guidance on when to use each option.
Specifically, the article covers:
- Source filter: Useful for migrating a subset of table data, but cannot be combined with parallelism settings.
- Parallel load with partitions-auto: Recommended for migrating complete table data with partitions.
- Parallel load with subpartitions-auto: Recommended for tables with limited partitions but huge subpartitions.
- Parallel load with partition-list and subpartitions-auto: Suitable for migrating selected partitions with subpartitions in parallel.
- Parallel load with partitions-list: Recommended for migrating specific partitions from a table.
- Parallel load with ranges: Recommended for unpartitioned tables or tables with fewer partitions but a large amount of data.
- Conclusion: Summarizes the best practices and provides additional resources.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Aug 12
2025
2025
Improve AWS DMS continuous replication performance by using column filters to parallelize high-volume tables
Apr 30
2024
2024
Perform a side-by-side upgrade in AWS DMS by moving tasks to minimize business impact
May 7
2024
2024
Minimize downtime when migrating your Oracle database to Amazon RDS for Oracle with transportable tablespaces and AWS DMS
May 8
2024
2024
5 best practices for accelerating research computing with AWS
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.