Niels SQL Server Blog : New release of SqlClrProject
"The SqlClrProject is a project type for Visual Studio 2005 for creation and deployment of assemblies to SQL Server 2005. It consists of templates for both Visual C# (C#) and Visual Basic (VB) with skeleton code for creation of CLR methods to be used as stored procedures, User Defined Functions (UDF's), triggers, User Defined Types (UDT's) and User Defined Aggregates (UDA's).
...
For you who have used the SQL Server Project project type from VS to do this, you may wonder what the differences are. Things that the SqlClrProject allows you to do, which the VS SQL Server project can't do:
Automatic creation of T-SQL deployment scripts.
Automatic creation of T-SQL DML scripts for testing of the created objects.
Ability to alter an assembly and only deploy newly added methods from the assembly.
Ability to create objects in a non default schema "schemaname.objectname".
..."
Very cool. I dig the creation of the T-SQL deployment scripts feature.
I script everything for SQL deployment. Doesn't matter if it is for Dev, QA or production, it's all scripted. This makes source control easy, Dev to QA to Prod migration easier, etc, etc.
So this addin will be something I'll have to very close look at when we move to SQL2k5 (mid-next year).
No comments:
Post a Comment
NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...
ALL comments are moderated. I will review every comment before it will appear on the blog.
Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...
I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...
Please see my comment policy for more information if you are interested.
Thanks,
Greg
PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...