On Thu, Dec 31, 2009 at 1:45 PM, akp geek <akpg...@gmail.com> wrote: > Hi All - > We have 2 databases test and prod. Now they are out of sync ( of > course they will be to some extent ). But there are some functions in some > schemas. we have to sync from prod to test. What I wanted to ask, is there > any tool that you recommend for version control. Because we are having tough > time tracking the changes
I've used the poor man's version control in the past. Make a table: create table version_control(id numeric primary key, description text, applied timestamp default now()); And then in every bit of DDL you submit to the DB, you put a single line at the top to insert the proper values to identify it. Then you can just compare the various dbs' version_control tables to see what's missing etc. Assuming you don't let tom, dick, harry and all their friends run ddl on the prod / staging / qa databases and pay attention to what you're doing it should work well. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
