Обсуждение: Migration of db
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
Regards
2009/12/31 akp geek <akpgeek@gmail.com>: > 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 > Regards You could always use Post Facto: http://www.post-facto.org/ Note, however, it's still in alpha. Regards Thom
On Thu, Dec 31, 2009 at 1:45 PM, akp geek <akpgeek@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.
akp geek wrote on 31.12.2009 21:45: > 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 > > Regards Have a look at Liquibase: www.liquibase.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > 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 Create a git repo, and enforce that all DDL changes must be made by using checked-in text files containing the changes. Each file should state at the top of it when it was applied to each box. As an aside, if you are syncing *from* prod to test, your process is badly broken. :) - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 201001040747 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAktB46wACgkQvJuQZxSWSsgWNQCfR8BX5tJg3Uc/R8DdPYOUg4cT x/UAoNsu60955j7coU/6vw+r0XZ9F28k =STQi -----END PGP SIGNATURE-----