Migration of db

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