schema and data compare between Oracle and MariaDB/MySQL

Hi,

Once i import all data from a dmp file to an orace 11gR2 ex / Oracle 12c to MariaDB/MySQL InnodB cluster, I'd like to compare the different in schema in oracle and MariaDB, any kind of tools for windows can compare both ?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martyn SpencerSoftware Developer / Linux System Administrator / Managing DirectorCommented:
There are many schema comparison tools so you would need to check that they support basic comparisons with the ability to map data types supported by the different databases. A quick search picks up the following:

http://www.dbsolo.com/schema_comparison.html
https://www.aquafold.com/aquadatastudio_features

I have used software from here before: https://www.upscene.com/

There are many others as well. Some open source tools also exist.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
so they are to compare totally diff DB?

"I have used software from here before: https://www.upscene.com/"

this one seems no SW to compare schema, or you are referring to database workbench. ?
0
Martyn SpencerSoftware Developer / Linux System Administrator / Managing DirectorCommented:
I am referring to Database Workbench. When I used it, it had a schema comparison tool. As to whether they compare totally different database types, that is something you will want to confirm, but IIRC Database Workbench will do, but I had to set up field type mappings.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

marrowyungSenior Technical architecture (Data)Author Commented:
"When I used it, it had a schema comparison tool.
"
pro edtion only ! I am checking it out too !

what is  IIRC?
0
Martyn SpencerSoftware Developer / Linux System Administrator / Managing DirectorCommented:
IIRC = If I recall correctly

It's a while since I used it, so there may now be new editions. There are numerous tools for database administrator, many that are free, but in my experience the free ones have limited comparison capabilities when it comes to comparing different schemas from different database systems.

Are you looking to compare just the schema definition, or data as well? The latter, for a large database, could be quite time consuming.

Edit: DBSolo specifically states that it compares schemas from different database engines and it looks to be one of the lowest cost of the commercial tools I have seen. It also has a free trial, so you can see if it meets your requirements.
0
marrowyungSenior Technical architecture (Data)Author Commented:
" many that are free, but in my experience the free ones have limited comparison capabilities when it comes to comparing different schemas from different database systems."

sure

"Are you looking to compare just the schema definition, or data as well? "

both ! actually schema first and see how well the convertion will be.

"The latter, for a large database, could be quite time consuming."

this one :   https://www.upscene.com/ ?

as it check everything ?

"Edit: DBSolo specifically states that it compares schemas from different database engines and it looks to be one of the lowest cost of the commercial tools I have seen."

tks.
0
Martyn SpencerSoftware Developer / Linux System Administrator / Managing DirectorCommented:
"The latter, for a large database, could be quite time consuming."
What I mean is that comparing data between two large databases could be very time consuming. If it is a one-off, it's probably not an issue. If it is something regular, optimising the comparison would be important. I am, perhaps, stating the obvious here.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"What I mean is that comparing data between two large databases could be very time consuming. "

true !
0
marrowyungSenior Technical architecture (Data)Author Commented:
let me try and update you later.
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks man, I might come back later but hopefully not.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.