How to push SQLCLR updates to your (CI) server

Question

I'm re-using some .NET code between SQL 2005 server and WinForm clients using SQLCLR.

This code has dependencies beyond .NET 2.0 which means I have to add these assemblies on the server machine (e.g. CREATE ASSEMBLY).

I'm trying to do this as part of a CI build and am wondering what methods have worked best.

Answer 1

Create an *.sql file with the sequence:

1. DROP FUNCTION ...
2. DROP ASSEMBLY ...
3. CREATE ASSEMBLY ...
4. CREATE FUNCTION ...

and call it with sqlcmd as part of your build.