Solved

Comparing Table data between Oracle and MySQL

Posted on 2014-03-31
2
453 Views
Last Modified: 2014-04-09
Hi,

I have  2 servers in my network (1) in Oracle 10g (2) in MySQL.
The 2 server should have the same table and data.

My question is, is there a tool(software/freeware) where I can compare the data between the same table data between the 2 servers?

*PS: I've tried DB-SOLO but it crashed when I tried to compare. The largest data I have in a table in the schema is around 1 million records.
0
Comment
Question by:csharp_learner
2 Comments
 
LVL 24

Accepted Solution

by:
mankowitz earned 350 total points
ID: 39966299
There are others. Navicat comes to mind
0
 
LVL 13

Expert Comment

by:magarity
ID: 39967176
You can always just set up ODBC between the two servers and then query for differences like select * from table1 minus select * from dblink.table2
http://planet.mysql.com/entry/?id=17948
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now