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?

profile picture
KG
質問済み 1年前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, and RENAME TABLE.
  • Using an ALTER TABLE table_name ADD COLUMN column_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.

回答済み 1年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ