Database table compare ?

[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]

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]

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]

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]

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]

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]

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

[markcasias]

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

thanks,

mark

[TonHu]

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

If you had only looked 2 posts up...

[trurl00]

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

www.diffkit.org

cheers,

Trurl00