Niels SQL Server Blog

 As I have blogged about before, I am not terribly pleased with the deployment mechanism of assemblies to SQL Server 2005 from the "SQL Server Project" project-type in Visual Studio 2005, and I created my own MSBUILD deployment tasks instead. Sporadically I have uploaded these tasks for general consumption and the latest realease targetting the April CTP of SQL Server 2005 and .NET can now be downloaded from here. Nothing has changed in this release from the previous release. However I still want to point out a couple of things:

• These tasks generates script files with the T-SQL syntax for the deployment.
• Partial support for ALTER ASSEMBLY
• Support for deploying different versions of the same assembly
• Support for the SqlFacet attribute. By using the SqlFacet attribute you can define size of parameters (think nvarchar) as well as size and precision (for decimal etc). The attribute is not restricted to parameters, but can be used for return types as well.

There is actually one thing that has changed, I have added Visual Studio project and item templates to the download. The project template brings automatically in the necessary build- and type conversion- files for the deploymet task, and the item templates contains some skeleton code for procedure/functions/triggers/aggregates and UDT's. Please note that the templates do not do automatic deployment from the build menu, you still need to do the deployment from the command line. So, what are you waiting for - go and get the download.
Filed under: Yukon