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
已提问 2 个月前168 查看次数
3 回答
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
已回答 2 个月前
  • 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
已回答 2 个月前
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
专家
已回答 2 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则