Re: [GENERAL] Schema comparison tool

2005-02-20 Thread Martin Boese
There is a program called pgdiff.. but I could not really make it work and it seems to be quiet old and unmaintained: http://pgdiff.sourceforge.net/ Martin ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://w

Re: [GENERAL] Schema comparison tool

2005-02-18 Thread Robert Treat
Agreed, the EMS product really is a slick tool. On another front, somewhere on my todo list is to add database diffing abilities to phppgadmin. There's a multiple db connection patch floating around that looks like it will be a help; if I can clear my schedule up enough I might get back to th

Re: [GENERAL] Schema comparison tool

2005-02-16 Thread Rich Shepard
On Wed, 16 Feb 2005, Ian Harding wrote: I keep scripts for drop/creation or replacement of each type of object, Jeff Amiel <[EMAIL PROTECTED]> 02/15/05 7:01 AM >>> I'm looking specifically for a tool to help compare 2 database schemas (nominally, production and development) and generate the approp

Re: [GENERAL] Schema comparison tool

2005-02-16 Thread Ian Harding
I keep scripts for drop/creation or replacement of each type of object, and a shell script to run them in order. I only make changes in the scripts. They can be run one at a time if only one type of object has changed or been created. I keep backups of data only, and have an intermediate step in

Re: [GENERAL] Schema comparison tool

2005-02-16 Thread Grant McLean
On Tue, 2005-02-15 at 15:01 +, Jeff Amiel wrote: > I'm looking specifically for a tool to help compare 2 database schemas > (nominally, production and development) and generate the appropriate SQL > (that can be later executed) to bring the to schema's into sync. [snip] > What does the rest o

Re: [GENERAL] Schema comparison tool

2005-02-15 Thread Bradley D. Snobar
The database comparer tool is one of EMS better products. http://www.sqlmanager.net/ http://www.sqlmanager.net/products/postgresql/dbcomparer Jeff Amiel <[EMAIL PROTECTED]> wrote: >I'm looking specifically for a tool to help compare 2 database schemas >(nominally, production and development) a