Re: upgrading a schema

sualeh.fatehi_at_gmail.com wrote:
> The free, open-source SchemaCrawler tool will compare the schema and
> data. 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 libraries are required.
>
> Sualeh Fatehi.

How does running diff on the two outputs help me generate the DDL statements to bring the target to the same level as the source?

Without that there is not much value - I could write the same program in about 20 minutes. Received on Wed Sep 20 2006 - 14:54:42 CDT