Table Comparison software?

Thread view:

Rhino - 06 Oct 2005 17:21 GMT

Is anyone aware of any software - freeware, shareware, or commercial - that
can be used to compare the contents of two tables to see if they are
identical, or, if not, to highlight the differences between them?

Ideally, such a program would compare tables from different databases, e.g.
DB2 and MySQL, and would be platform-agnostic so that databases on different
operating systems could still be compared but those aren't necessarily "must
have" features.

I would imagine that someone involved in software testing might be aware of
tools along the lines that I am describing.

Signature

Rhino

Reply to this Message

John Currier - 07 Oct 2005 14:29 GMT

> Is anyone aware of any software - freeware, shareware, or commercial - that
> can be used to compare the contents of two tables to see if they are
[quoted text clipped - 10 lines]
> --
> Rhino

It wouldn't be very difficult to write a simple version of something
like that using JDBC. By simple I mean dump the contents of each table
to a file (dealing with binary data in the process) and use another
tool that's good at performing file comparisons (e.g. WinDiff).

John Currier
http://schemaspy.sourceforge.net

Reply to this Message

Rhino - 14 Oct 2005 13:42 GMT

> > Is anyone aware of any software - freeware, shareware, or commercial - that
> > can be used to compare the contents of two tables to see if they are
[quoted text clipped - 18 lines]
> John Currier
> http://schemaspy.sourceforge.net

Yes, I'm aware that it wouldn't be terribly difficult to write something for
myself but I'm just trying to see if something already exists that would do
the job so that I can avoid taking time out to write my own utility.

Rhino

Reply to this Message

sualeh.fatehi@gmail.com - 10 Oct 2005 14:09 GMT

Rhino,

I am the author of SchemaCrawler. It is open source, and hosted on
SourceForge. http://sourceforge.net/projects/schemacrawler/

SchemaCrawler is written in Java, and is a command line tool, with an
ant task too. It can dump your database schema (metadata), as well as
data into a text file (plain text, CSV or XHTML). All of these text
file formats are designed to be diff-ed. (You will need to use your
favorite diff tool to do the diffs.)

I have successfully used SchemaCrawler to compare databases from one
database type to another (such as DB2 and MySQL), and also an older
schema with a newer version of the schema.

Please email me separately if you need help in using this tool. Enjoy.

Sualeh.

Reply to this Message

Rhino - 14 Oct 2005 14:19 GMT

> Rhino,
>
[quoted text clipped - 14 lines]
>
> Sualeh.

Thanks for the suggestion, Sualeh! I'll let you know if I have any problems
with SchemaCrawler.

Rhino

Reply to this Message

Table Comparison software?

Free Magazines