| From: | Sualeh Fatehi <sualeh(dot)fatehi(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Schema migration tools? |
| Date: | 2008-05-20 11:59:50 |
| Message-ID: | 5df50dc8-ed1a-400c-9ecf-c60e2d0bca8e@c58g2000hsc.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Christophe,
I agree with Dr. DeSoi that it may not always be possible to automate
schema transformations. However, if you need to compare the metadata
between two databases, the free, open-source SchemaCrawler for SQL
Server tool will do this for you. You can take human-readable
snapshots of the schema and 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.
SchemaCrawler is available at SourceForge:
http://schemacrawler.sourceforge.net/
Sualeh Fatehi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2008-05-20 12:07:22 | Re: escaping and quoting |
| Previous Message | Albe Laurenz | 2008-05-20 11:37:00 | Re: Postgre Deployment and Installation options |