Re: [GENERAL] Simple schema diff script in Perl
If you are still looking for a program to compare databases, take a look at SchemaCrawler - http://schemacrawler.sourceforge.net Sualeh. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Comparing 2 databases
The free, open-source SchemaCrawler for SQL Server tool is desinged to do just this. 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Schema diff tool?
Dave, The free and open-source SchemaCrawler for PostGresql tool will do what you need. 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. 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. SchemaCrawler comes with SchemaCrawler Grep, a command line tool that allows you to search your schema for columns and tables that match a regular expression. SchemaCrawler can also generate E-R diagrams. SchemaCrawler is a free, open-source, cross-platform (operating system and database) tool, written in Java, that is available at SourceForge: http://schemacrawler.sourceforge.net/ Sualeh Fatehi. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] A compare and/or sync. database structure?
The free, open-source SchemaCrawler for SQL Server tool is desinged to do just this. 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Schema migration tools?
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pg_dump - schema diff compatibility
SchemaCrawler for PostgreSQL will allow you to do the diffs. With SchemaCrawler for PostgreSQL, you can take human-readable snapshots of the schema and data, for later comparison. SchemaCrawler outputs details of your schema (tables, views, procedures, and more) in a diff- able plain-text format (text, CSV, or XHTML). You can order data alphabetically, or by ordinal order. SchemaCrawler can also output data (including CLOBs and BLOBs) in the same plain-text formats. SchemaCrawler for PostgreSQL is free and open-source (under the GPL), and is available at SourceForge: http://schemacrawler.sourceforge.net/ Sualeh Fatehi. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Upgrading schemas
The free, open-source SchemaCrawler tool will compare the schema and data. 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. 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. SchemaCrawler is free, open-source, cross-platform (operating system and database) tool, written in Java, that is available at SourceForge: http://schemacrawler.sourceforge.net/ You will need to provide a JDBC driver for your database. No other third-party libraries are required. Sualeh Fatehi. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly