Re: DDL diff utility?
От | Robert Treat |
---|---|
Тема | Re: DDL diff utility? |
Дата | |
Msg-id | 1063981246.30308.1673.camel@camel обсуждение исходный текст |
Ответ на | DDL diff utility? (Steve Manes <smanes@magpie.com>) |
Список | pgsql-general |
On Fri, 2003-09-19 at 07:42, Steve Manes wrote: > My company offers an ASP service for advertising companies using PG. > For contractual reasons, each client gets its own replicated database. > This presents a problem whenever a new feature/fix requires a DDL change > which must be rolled out across N databases. Currently, we keep track of > these changes via a central text file in CVS with manually entered DDL > updates. The problem is making sure that overworked developers actually > log all these changes. > > What would be better is a DDL 'diff' utility that would look at a master > and target database and generate the necessary ALTER statements needed > to make the target db look like the master. > > Is anyone aware of such a tool for PG? I've only found it for MSSQL. > Check the mailing list archives, IIRC there is a project on sourceforge that does this. It's a little weird though, I think it was written in tcl and required a running webserver to make connections. HTH, Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
В списке pgsql-general по дате отправления: