The database comparer tool is one of EMS better products. http://www.sqlmanager.net/ http://www.sqlmanager.net/products/postgresql/dbcomparer Jeff Amiel <jamiel@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > __________________________________________________________________ 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
