How to migrate data from Aurora MySQL to on-premises Oracle database as a backfill?
I see here Database Migration Step-by-Step Walkthroughs and elsewhere how to migrate from an on-premises database to AWS. However, it’s not clear how to do the reverse so that we go from AWS to an on-premises Oracle database.
In general, we’re a fan of going to AWS from on-premises. However, there are those times one must take a step back for now.
So after switching our stuff to start populating on-premises Oracle database tables, how does one backfill the old data from Amazon Aurora MySQL to the on-premises Oracle database?
- Newest
- Most votes
- Most comments
Aurora MySQL is not listed as a one of the "Source data providers for DMS Schema Conversion" https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Sources.html#CHAP_Introduction.Sources.SchemaConversion
Aurora MySQL is supported as a source database for AWS DMS, so it is possible to migrate to on-premise itself.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Sources.html
Also, since Aurora MySQL is a managed service, migration using third-party tools may be difficult.
So it may be a good idea to consider migrating using a managed service such as AWS DMS.
DMS can be migrated from Oracle to Aurora MySQL, but not from Aurora MySQL to Oracle, as the schema cannot currently be changed.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Sources.html#CHAP_Introduction.Sources.SchemaConversion
Relevant content
- asked 2 years ago
- asked 2 years ago
AWS OFFICIALUpdated 2 months ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
I appreciate the answer. I need to dive in deeper. At a glance, I do not see Aurora MySQL listed as a one of the "Source data providers for DMS Schema Conversion" https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Sources.html#CHAP_Introduction.Sources.SchemaConversion Did I miss something? Thanks!
Sorry, I missed that part of the documentation. DMS can migrate from Oracle to Aurora MySQL, but I don't think it can migrate from Aurora MySQL to Oracle.
No worries, Riku_Kobayashi. I appreciate the time spent on this. :)
Perhaps the thing to do is to edit the answer so that it can be accepted. Are you able to edit the answer, Riku_Kobayashi?