Schema comparison tool
От | Jeff Amiel |
---|---|
Тема | Schema comparison tool |
Дата | |
Msg-id | 42120EC9.3040702@istreamimaging.com обсуждение исходный текст |
Ответ на | Re: CURSORs and selects with parameters (Dan Sugalski <dan@sidhe.org>) |
Ответы |
Re: Schema comparison tool
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: