Database table compare ?

Do you have anything to share with other users? Your opinions about our programs, suggestions for future products - everything goes here.
Post Reply
whiri02
Posts: 23
Joined: Tue Oct 12, 2004 2:23 pm
Location: UK

Database table compare ?

Post by whiri02 »

Hi I'm looking for some software to run on a PC to compare 2 database tables. These tables might be big, and I do not want to write sql to extract the data to flat files but compare a table in one database directly with a table in another database. In particular I'm interested in Oracle.
Has anyone got any recommendations ?
TIA

Guest

Post by Guest »

I guess not....

I have found CDB Database Comparator from www.dbBalance.com which seems to do the job. 14 day free trial so I'll update this thread later with my results.

grigsoft
Site Admin
Posts: 1673
Joined: Tue Sep 23, 2003 7:37 pm
Contact:

Post by grigsoft »

Hello,
Sorry I'm on the road and I could not answer earlier. Compare It! does not have such ability, you will have to export data to plain text. In addition to tool you have found you can check our partner - apexsql.com, they have database Diff tool, maybe it would help you.

whiri02
Posts: 23
Joined: Tue Oct 12, 2004 2:23 pm
Location: UK

Post by whiri02 »

Thanks for the pointer. Apexsql products look good, but unfortunately according to their FAQs page "ApexSQL Diff is designed to work with MSSQL7 and MSSQL2000 only" .
Cheers

whiri02
Posts: 23
Joined: Tue Oct 12, 2004 2:23 pm
Location: UK

Post by whiri02 »

An update on CDB - It uses ODBC so can collect data from any ODBC compliant database. It does a good job of comparing content (highlighting differrences, allowing you to tailor the SQL that extracts data, and hence target the compare). It also can compare the structure of the tables.

transparent_reader
Posts: 1
Joined: Fri Feb 27, 2009 8:37 am

Post by transparent_reader »

there is a free opensource application that can compare tables from different databases. you can download the file from http://sourceforge.net/projects/comparezilla/

arragon
Posts: 1
Joined: Thu Mar 18, 2010 12:33 pm

Re: Database table compare ?

Post by arragon »

You might also be interested in http://www.citrustechnology.com/solutio ... comparison. It's not free, but there is a trial download.

markcasias
Posts: 1
Joined: Fri Mar 12, 2010 6:37 am

Re: Database table compare ?

Post by markcasias »

hope you can provide a link for a free download.....

thanks,

mark
Last edited by markcasias on Wed Mar 24, 2010 3:35 pm, edited 1 time in total.

TonHu
Posts: 100
Joined: Mon Sep 29, 2003 10:48 am
Location: Netherlands

Re: Database table compare ?

Post by TonHu »

markcasias wrote:hope you can provide a link for a free download.....
If you had only looked 2 posts up... :cry:

trurl00
Posts: 1
Joined: Wed Nov 10, 2010 1:41 pm

Re: Database table compare ?

Post by trurl00 »

There is an Open Source project that is designed specifically to compare large SQL tables:

www.diffkit.org

cheers,

Trurl00

Post Reply