Comparing Table data between Oracle and MySQL

Posted on 2014-03-31
Medium Priority
Last Modified: 2014-04-09

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.
Question by:csharp_learner
LVL 24

Accepted Solution

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

Expert Comment

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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
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…
Via a live example, show how to take different types of Oracle backups using RMAN.

627 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