Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Schema migration tools?
- From: Sualeh Fatehi <sualeh(dot)fatehi(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: Schema migration tools?
- Date: Tue, 20 May 2008 04:59:50 -0700 (PDT)
- Message-id: <5df50dc8-ed1a-400c-9ecf-c60e2d0bca8e(at)c58g2000hsc(dot)googlegroups(dot)com>
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
- Follow-Ups:
- Re: Schema migration tools?
- From: Scott Ribe
- Re: Schema migration tools?
- Prev by Date: Re: escaping and quoting
- Next by Date: best er modeling tool for postgreSQL
- Previous by thread: getting number of affected rows in dblink_exec
- Next by thread: Re: Schema migration tools?
- Indexes: