スキップしてコンテンツを表示

Migrating Views from on-prem MySQL to RDS MySQL

0

I seem to be missing something, I ran a test run of DMS and all my tables were properly migrated. However none of my views came along for the ride. Is there a way to include the views in the migration. Are there are other things that are not migrated by default? Triggers, stored procedures, functions?

Thanks!

質問済み 5年前994ビュー
2回答
0

DMS will only migrate the bare minimum components to perform the data migration i.e. table structure, primary key etc. It does not migrate foreign keys, views, procedures etc.

You are doing a homogeneous migration i.e. MySQL to MySQL. Can't you restore using a backup / restore? Any particular reason you are choosing DMS?

Check this link: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html

Edited by: VMG on Feb 2, 2021 12:57 PM

Edited by: VMG on Feb 2, 2021 12:58 PM

回答済み 5年前
0

Ok, I wasn't sure if DMS was something equivalent to mysqldump. I guess it's more for migrating between database engines.

Thanks!

回答済み 5年前

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

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

関連するコンテンツ