I have encountered an issue with the SQL Packager. I have a .Net CLR UDA which takes in an additional parameter. The packager ignores this aggregate and omits it from the generated SQL batches for the database ugrade.
If I run the SQL code manually to create the aggregate, there is no problem and it all works. However, it would be preferable for this to work in the packager.
My create aggregate SQL is as follows:-
CREATE AGGREGATE Helper.[Concatenate](@input NVARCHAR(MAX), @separator NCHAR(1))
EXTERNAL NAME [MyDll].[Aggregates.Concatenate];