Database table compare ?

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

Database table compare ?

Postby whiri02 » Tue Jul 26, 2005 1:22 pm

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

Postby Guest » Wed Jul 27, 2005 1:59 pm

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: 1671
Joined: Tue Sep 23, 2003 7:37 pm

Postby grigsoft » Fri Jul 29, 2005 4:21 pm

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: 22
Joined: Tue Oct 12, 2004 2:23 pm
Location: UK

Postby whiri02 » Sun Jul 31, 2005 9:26 pm

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: 22
Joined: Tue Oct 12, 2004 2:23 pm
Location: UK

Postby whiri02 » Sun Jul 31, 2005 9:37 pm

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

Postby transparent_reader » Fri Feb 27, 2009 8:44 am

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 ?

Postby arragon » Thu Mar 18, 2010 12:35 pm

You might also be interested in http://www.citrustechnology.com/solutions/data-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 ?

Postby markcasias » Tue Mar 23, 2010 5:28 am

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 ?

Postby TonHu » Tue Mar 23, 2010 11:28 am

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 ?

Postby trurl00 » Wed Nov 10, 2010 1:44 pm

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

www.diffkit.org

cheers,

Trurl00


Return to “General discussion”

Who is online

Users browsing this forum: Gingko and 1 guest