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달 전167회 조회
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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠