The database comparer tool is one of EMS better products.
http://www.sqlmanager.net/http://www.sqlmanager.net/products/postgresql/dbcomparer
Jeff Amiel <jamiel@istreamimaging.com> 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.
>
>Option1 :
>pg_dump -s firstdatabasename > first
>pg_dump -s seconddatabasename > second
>diff first second
>(obviously wont generate SQL to remedy the differences)
>
>Option2:
>pgdiff (http://gborg.postgresql.org/project/pgdiff/projdisplay.php)
>(old abandoned perl project that doesn't work...)
>
>Option 3:
>pgdiff (http://gborg.postgresql.org/project/pgdiff/projdisplay.php)
>(old abandoned TCL project which requires AOLServer to run???)
>
>Option 4:
>EMS PostgreSQL DB Comparer
>(http://www.sqlmanager.net/products/postgresql/dbcomparer)
>Slick tool...fairly cheap ($69)...doesnt let you exclude certain
>specific tables/sequences/databases, but otherwise, pretty functional.
>
>What does the rest of the postgreSQL admin community do in order to
>"bring-live" database schema changes from their development environment
>to production? Are there other options/techniques out there?
>
>Any help would be appreciated.
>
>Jeff
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp