Re: Testing validation tool

Paul, The SchemaCrawler tool enables you to take human-readable snapshots of the schema and data, for later comparison. Comparisons are done using a standard diff tool (such as WinMerge on Windows). SchemaCrawler outputs data (including CLOBs and BLOBs) in a diff-able plain-text format (text, CSV, or XHTML). SchemaCrawler also outputs details of your schema (tables, views, procedures, and more) in the same plain-text formats. You can be selective about which tables and which columns you want to look at. You can even execute custom SQL statements. You may not get the summary information that you are looking for, but you can customize to your needs using well defined programmatic extension points. 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. SchemaCrawler is written in Java, and is platform-independent. SchemaCrawler is free and open-source, and is available at SourceForge: http://schemacrawler.sourceforge.net/ Hope this helps. Sualeh Fatehi.