|
|
Posted by Erland Sommarskog on 12/03/06 12:30
Mark Olbert (ChairmanMAO@newsgroups.nospam) writes:
> Do you have any references on using version control with SqlServer 2000
> and 2005? I'm not familiar with using version control on database
> objects.
If you are familliar to version control, you are familiar to version control
of database objects: you check out, edit, compile and test until you are
satisfied and then you check in. When you need to set a baseline for
delivering to test or production, you set a label so that you know what
you shipped.
Of course tables are a little special, since you don't test them in the
same manner, and when you change a table you will need to compose an
upgrade script to preserve the data in some way, but that you need to do
without version control as well.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|