Split one table into multiple tables using AWS DMS?

0

Giving an example to explain my scenario - FileA has 100 attributes. FileB has 300 attributes. The attributes in Files A and B can be from multiple tables. These files are present in S3. We are going to import Files A and B into RDS Postgres. Now this Postgres will have Table A --> generated from File A (100 attributes) and Table B --> generated from File B (300 attributes)

We now want to split Tables A & B into multiple smaller tables using AWS DMS. Source Postgres (Tables A & B) --> AWS DMS --> Target Postgres (Tables C, D, E, F) Is this possible? Any advice to implement this scenario? Please help

1개 답변
1

It may be possible to use AWS DMS for your case but you may be better off using a Stored Procedure or an ETL tool (if you are already using one) instead.

The ideal tool will depend on factors such as

  • Is the source and target PostgreSQL instance the same?
  • Is this a one-time or an ongoing process?
  • Are the smaller tables a subset of the rows of the larger tables? Or is it a subset of the columns? Or is it a more complex logic?
  • Are you already using AWS DMS for something else or are you planning to introduce DMS just for this activity?
AWS
vg
답변함 일 년 전

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

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

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

관련 콘텐츠