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/viewtopic.php?t=9883

Many thanks!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569

[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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569

[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
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569

[chrisrm]

Any idea when this fix will be included?