Sunday, February 19, 2012

Deploy CLR SQL Project using MSBuild

What is the "official" line on deploying CLR SQL projects through the use of build scripts like NANT and MSBuild?

I'm obviously keen to hook up my project to my continuous integration build but the only things I have found that touch on the subject are:

    Do it by hand yourself using xcopy of assemblies and T-SQL

    Use SQLCLR project

    This old post that says what *might* happen

Cheers

I don't really understand your question; are you asking what MS says about using NANT/MSBUILD for deployment - or are you asking what the community thinks?

Anyway, if your aim is to automate your deployment, and continuous build my preferences would be:
1. scripting
or
2. SQLCLR project (I would say that as I am the developer)

I would not use the VS built in SQL Server project type, as I feel I do not have the control as I would like.

Niels

No comments:

Post a Comment