Aggregate Ignored By packager

chrisrm

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))
RETURNS NVARCHAR(MAX)
EXTERNAL NAME [MyDll].[Aggregates.Concatenate];
GO

peter.peart

Hi Chris,

Many thanks for your post. Can you confirm if you experience this behaviour with SQL Packager 6.3?

There is a sticky detailed below with the latest patch release 6.3:

http://www.red-gate.com/messageboard/vi ... php?t=9883

Many thanks!

Pete

chrisrm

Pete,

I am using version 6.3.1.7 of the packager.

Chris

peter.peart

Hi Chris,

Thanks for letting me know. I have one of our devs looking at this now; hopefully we should be able to include a patch for this soon for you.

Pete

peter.peart

Hi Chris,

Just so you are aware, this issue has been raised under ref SPA-540. I will let you know as and when we have a fix for it.

Pete

chrisrm

Any idea when this fix will be included?