Solved

Comparing Table data between Oracle and MySQL

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
create a nested synonym 4 28
make null the repeated levels 2 31
mysql database, schema and table creation 13 57
MySQL InnodDB Import from mysqldump takes forever. 2 36
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

828 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