marrowyung
asked on
migrate from Oracle to MySQL
hi,
what is the official method to migrate from Oracle to MySQL ?
what is the official method to migrate from Oracle to MySQL ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
slightwv,
"Remember, most database migrations is only data and structure. Any code will need manual migration of some type."
yes, Ispirer said their tools can do it too and I know we also need careful check.
"Don't fear the documentation."
no fear, but this document seems very high level, and not about how to migration from Oracle to MySQL.
Doug Walton,
"Amazon Web Services (AWS) has a nice tool called Database Migration Service (DMS): "
that tools is for migrating Oracle to their cloud service DB, right ?
"Remember, most database migrations is only data and structure. Any code will need manual migration of some type."
yes, Ispirer said their tools can do it too and I know we also need careful check.
"Don't fear the documentation."
no fear, but this document seems very high level, and not about how to migration from Oracle to MySQL.
Doug Walton,
"Amazon Web Services (AWS) has a nice tool called Database Migration Service (DMS): "
that tools is for migrating Oracle to their cloud service DB, right ?
>>no fear, but this document seems very high level, and not about how to migration from Oracle to MySQL.
It gives you a place to start with the tool. You can then dig into the specifics you need for your migration. Not all migrations will be the same.
If you are looking for a step by step guide, I'm not sure you will find one.
>>said their tools can do it
I doubt it does it well. I've not seen tool generated SQL that works all that well let alone actual business logic in code.
It gives you a place to start with the tool. You can then dig into the specifics you need for your migration. Not all migrations will be the same.
If you are looking for a step by step guide, I'm not sure you will find one.
>>said their tools can do it
I doubt it does it well. I've not seen tool generated SQL that works all that well let alone actual business logic in code.
ASKER
"I doubt it does it well. I've not seen tool generated SQL that works all that well let alone actual business logic in code."
yeah, I believe so, it will be the same case as Oracle to MSSQL / DB2.
do you think migrating to DB2 also the same case?
yeah, I believe so, it will be the same case as Oracle to MSSQL / DB2.
do you think migrating to DB2 also the same case?
>>do you think migrating to DB2 also the same case?
Migrating code between any two products will be the same.
Migrating code between any two products will be the same.
ASKER
tks.
ASKER
tks.
The migration tool from AWS doesn't have to be used to migrate to their services, but since it runs from an instance in the cloud it will need network access to both databases.
ASKER
sir,
why you say that ?
why you say that ?
Oh sorry nevermind. I looked it up and I guess they no longer support that.
https://aws.amazon.com/dms/faqs/
https://aws.amazon.com/dms/faqs/
I suppose if you are setting up live replication as you are migrating you can use that but it is a replication product not a migration product.