Page 1 of 1

Database table compare ?

Posted: Tue Jul 26, 2005 1:22 pm
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

Posted: Wed Jul 27, 2005 1:59 pm
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.

Posted: Fri Jul 29, 2005 4:21 pm
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.

Posted: Sun Jul 31, 2005 9:26 pm
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

Posted: Sun Jul 31, 2005 9:37 pm
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.

Posted: Fri Feb 27, 2009 8:44 am
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/

Re: Database table compare ?

Posted: Thu Mar 18, 2010 12:35 pm
by arragon
You might also be interested in http://www.citrustechnology.com/solutio ... comparison. It's not free, but there is a trial download.

Re: Database table compare ?

Posted: Tue Mar 23, 2010 5:28 am
by markcasias
hope you can provide a link for a free download.....

thanks,

mark

Re: Database table compare ?

Posted: Tue Mar 23, 2010 11:28 am
by TonHu
markcasias wrote:hope you can provide a link for a free download.....
If you had only looked 2 posts up... :cry:

Re: Database table compare ?

Posted: Wed Nov 10, 2010 1:44 pm
by trurl00
There is an Open Source project that is designed specifically to compare large SQL tables:

www.diffkit.org

cheers,

Trurl00