Table Comparison software?

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.
 >> Stay informed about: Table Comparison software? 

"John Currier" <md4curvs.RemoveThis@gmail.com> wrote in message
news:1128691772.474767.87500@f14g2000cwb.googlegroups.com...
> Rhino wrote:
> > 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.
> >
> > --
> > 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
>

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
 >> Stay informed about: Table Comparison software? 

<sualeh.fatehi DeleteThis @gmail.com> wrote in message
news:1128949780.894308.105780@g44g2000cwa.googlegroups.com...
> 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.
>
Thanks for the suggestion, Sualeh! I'll let you know if I have any problems
with SchemaCrawler.

Rhino
 >> Stay informed about: Table Comparison software?