DMS/CDC of a single table

0

I currently have a DMS task using the following:

Selection Rules where schema name is like 'BLAH' and Source table name is like '%', include

Transformation rules where schema name is like 'BLAH' and Source table name is like '', rename

There are some tables that has a lot of rows. Do I need to create a separate DMS task for those and exclude it from the existing DMS task? I don't mind having to do a resume solely for the big tables but I don't see that as an option. There is an option to select specific tables for validation, I don't think that check box applies to the Restart/Resume DMS.

Ed
asked a month ago142 views
3 Answers
0

for Transformation rules where schema name is like 'BLAH' and Source table name is like '', rename is rule target schema? if so make sure Source table name is like '%'

separately tables in different tasks based on size or lob is a good practice.

but try to keep transactionally related tables in one task so that any referential integrity (foreign key, etc) is maintained on target.

AWS
answered a month ago
  • How about if I just truncate that table on the target, will DMS automatically re-populate it?

0

It wont repopulate unless you

  • restart the task thereby reloading the tables
  • reload the table from table statistics (task has to be cdc only or full load and cdc)
AWS
answered a month ago
0

For large tables, it is recommended to migrate them separately from other tables for better performance and control.

  • Create separate DMS tasks - one task for the large tables only using selection rules to include just those tables, and another task for the remaining tables.
  • Use table filtering - Include only the large tables in the existing task using selection rules. Then create a new task to migrate the remaining tables.
  • Resume existing task for large tables - Pause the existing full migration task after it completes the smaller tables. Then modify the task to only include the large tables using selection rules, and resume it.
  • The resume option allows reusing the same task without creating a new one. Make sure to monitor the tasks closely for any issues with the large tables. The AWS DMS documentation has more details on using selection rules, transformations, filtering tables, and resuming tasks.
profile picture
EXPERT
answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions