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!

ben
質問済み 3年前573ビュー
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

VMG
回答済み 3年前
0

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

Thanks!

ben
回答済み 3年前

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

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

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

関連するコンテンツ