By using AWS re:Post, you agree to the Terms of Use
/Migrating Views from on-prem MySQL to RDS MySQL/

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!

2 Answers
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

answered a year ago
0

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

Thanks!

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions