Solved

Comparing Table data between Oracle and MySQL

Posted on 2014-03-31
2
450 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Creating and Managing Databases with phpMyAdmin in cPanel.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

705 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

15 Experts available now in Live!

Get 1:1 Help Now