Migrating Views from on-prem MySQL to RDS MySQL

Question

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!

Answer

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

Answer

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

Migrating Views from on-prem MySQL to RDS MySQL

Relevant content