Re: Schema comparison tool

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 this.

Robert Treat

On Tuesday 15 February 2005 16:31, Bradley D. Snobar wrote:
> The database comparer tool is one of EMS better products.
>
> http://www.sqlmanager.net/
> http://www.sqlmanager.net/products/postgresql/dbcomparer
>
> Jeff Amiel <jamiel(at)istreamimaging(dot)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(at)postgresql(dot)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
>
> ---------------------------(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

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL