Re: For Schema Comparision Experts

Amit,

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.

oracledba.amit_at_gmail.com wrote:
> Hi There,
>
> I have a task that needs me to compare two different schemas in two
> different databases.
>
> My issue is with connectivity. How do I use the information about the
> second database (ie the database Im not using currently).
>
> Your suggestions are most welcome.
>
> Thanking you in anticipation.
>
> Regards,
> Amit
Received on Mon Oct 09 2006 - 05:50:14 CDT