Niels SQL Server Blog

A week ago I wrote about the new and enhanced task dll for deployment of CLR assemblies to Yukon. Even though it was fairly functional at that time, there were a couple of things in it (or rather not in it) which I didn't like.

So I bit the bullet and fixed it. The new release has following added functionality:

• It can deploy CLR classes as SQL Server Yukon User Defined Types (UDT's).
• It can deploy CLR classes as SQL Server Yukon User Defined Aggregates (UDA's).
• If a UDT is used indirectly in Yukon (as a column type in a table for example) the table(s) or column(s) are dropped when re-deploying. Whether to drop the whole table or just the column(s) is user defined in the build file.
• Likewise, if a CLR method is used indirectly in Yukon (a UDF being part of a column definition etc.) the indirect dependencies are dropped when re-deploying. The handling of tables/columns are the same as for UDT's.

I am pretty pleased with the (so far) end result. Please download it if you want and comment here on what you think about it and what features you like, don't like want to see added, removed etc.