?
Solved

Comparing Table data between Oracle and MySQL

Posted on 2014-03-31
2
Medium Priority
?
470 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 24

Accepted Solution

by:
mankowitz earned 1400 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

771 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