Re: Track changes made to SQL Server
- From: xman <xman@xxxxxxxxxxxxxxxx>
- Date: Wed, 27 Feb 2008 11:31:40 -0800 (PST)
On Feb 26, 3:04 am, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:
John Sheppard (s...@xxxxxxxxxx) 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...@xxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: Track changes made to SQL Server
- From: John Sheppard
- Re: Track changes made to SQL Server
- References:
- Track changes made to SQL Server
- From: John Sheppard
- Re: Track changes made to SQL Server
- From: Erland Sommarskog
- Track changes made to SQL Server
- Prev by Date: Re: Error on Trigger Launch
- Next by Date: Using a "match" table to store multiple columns for parent data
- Previous by thread: Re: Track changes made to SQL Server
- Next by thread: Re: Track changes made to SQL Server
- Index(es):
Relevant Pages
|
