Re: How to compare two table structures?

From: <sualeh.fatehi_at_gmail.com>
Date: 8 Jun 2006 07:18:35 -0700
Message-ID: <1149776315.630184.143450@f6g2000cwb.googlegroups.com>

Vijay,

The open-source SchemaCrawler tool will do what you need. SchemaCrawler outputs details of your schema (tables, views, procedures, and more) in a diff-able plain-text format (text, CSV, or XHTML). SchemaCrawler can also output data (including CLOBs and BLOBs) in the same plain-text formats. You can use a standard diff program to diff the current output with a reference version of the output. SchemaCrawler can be run either from the command line, or as an ant task. A lot of examples are available with the download to help you get started.

SchemaCrawler is free, open-source, cross-platform (operating system and database) tool, written in Java, that is available at SourceForge: http://schemacrawler.sourceforge.net/

You will need to provide a JDBC driver for your database. No other third-party jars are required.

Sualeh Fatehi. Received on Thu Jun 08 2006 - 09:18:35 CDT