|
|
Posted by Sualeh Fatehi on 07/16/07 21:45
The free, open-source SchemaCrawler tool will do what you need. You
can take human-readable snapshots of the schema and/ or data, for
later comparison. Comparisons are done using a standard diff tool such
as WinMerge. 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. A lot of examples are
available with the download to help you get started. You will need to
provide a JDBC driver for your database, such as the free jTDS driver
for SQL Server.
You can download a pre-packaged version of SchemaCrawler for SQL
Server to get you started quickly. SchemaCrawler is available at
SourceForge:http://schemacrawler.sourceforge.net/
Sualeh Fatehi.
Navigation:
[Reply to this message]
|