"xman" <xman@xsqlsoftware.com> wrote in message
news:a5d9c513-804d-4eb4-90c6-e7fe3696c2ed@n75g2000hsh.googlegroups.com...
On Feb 26, 3:04 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> John Sheppard (s...@nospam.com) writes:
> > Does anyone know of a way to track changes to anSQLServerdatabase so
> > that I can easily run those changes at a later date?
>
> > That is, I want to make schema changes, and record those changes so that
> > I
> > can execute them 6 months later on a copy of the orignal database.
>
> Develop scripts and keep them under source control.
>
> If you forgot to that,SQLComparefrom Red Gate can be your rescue.
>
> --
> Erland Sommarskog,SQLServerMVP, esq...@sommarskog.se
>
> Books Online forSQLServer2005
> athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online forSQLServer2000
> athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

>As can xSQL Object from xSQL Software (http://www.xsqlsoftware.com)
>and what's even better you may not have to pay a dime for it as it is
>free for SQL Server Express and also free for other editions of SQL
>Server with some limitations.
>
>JC

Hmm, this looks pretty decent, I'll check it on my database tommorow...see
if it drops tables or alters..drop is

Thanks!
John