Does AWS DMS only support migration to brand new tables in the target DB?
0
We have a use case of migrating data from AWS DocumentDB to MySQL DB. In the target DB, we have an existing table where we want this ongoing migration to happen. Is this possible or does DMS only support migration to a brand new table in the target DB?
질문됨 일 년 전277회 조회
1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
Per the documentation, there is no limitation on the target table in a MySQL database destination.
Some of the limitations that are present are:
- The data definition language (DDL) statements
TRUNCATE PARTITION,DROP TABLE, andRENAME TABLE. - Using an
ALTER TABLE table_name ADD COLUMNcolumn_name statement to add columns to the beginning or the middle of a table. - Aurora Serverless is available as a target for Amazon Aurora version 1.
- Using an Aurora Reader endpoint.
Since it sounds like you are doing continuous replication, also take a look at the Ongoing replication task documentation.
답변함 일 년 전
