change-script

Strange behaviour when renaming a column in SQL Server 2008

I need to write some code for renaming a column in SQL Server 2008. When scripting that in Management Studio I got a double renaming : NAME1 ==> TEMPNAME ==> NAME2 BEGIN TRANSACTION GO EXECUTE sp_rename N'dbo.Table_1.columFirstName', N'Tmp_columSecondName_2', 'COLUMN' GO EXECUTE sp_rename N'dbo.Table_1.Tmp_columSecondName_2', N'colum...

Naming convention for database change scripts?

I plan on using a "base script" for my initial database version 1.0.0 but after that I will require change scripts which "upgrade" the database to newer versions. I'm not sure how to name these scripts in my repository. I was envisioning something along the lines of: Baseline-6.0.0.sql Patch-6.0.1.sql Patch-6.0.2.sql Patch-6.1.0.sql ...