Re: Database Out Of Sync

Posted in 2006

sualeh.fatehi@gmail.com — 31 Jan 2006 05:30:08 -0800 — source: Usenet: comp.databases.informix

There is a free, open-source, cross-platform (operating system and database) tool called SchemaCrawler on SourceForge that will compare schemas between two or more different systems. SchemaCrawler outputs details of your schema (and data) in a diff-able plain-text format (text, CSV, or XHTML). 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. http://schemacrawler.sourceforge.net/ Sualeh Fatehi.