Re: Migration of db

-----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(at)turnstep(dot)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-----