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