Red Gate forums :: View topic - CLR Dependancies
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

CLR Dependancies

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
sidetnee



Joined: 07 Jul 2008
Posts: 2

PostPosted: Mon Jul 07, 2008 11:27 am    Post subject: CLR Dependancies Reply with quote

Hi,

I am currently evaluating the packager product for use by our company.
I have encountered a few problems when trying to produce a package to upgrade from one version of our database to the next.

1) The dependancy detection for CLR assemblies, we have in our database 3 CLR assemblies, 2 of these are dependant on the third and require that it be created prior to any attempt to create them, this is not being picked up by the comparison engine and is failing. Is this a known issue?

2) i have a couple of CLR functions that are generating incorrectly, namely as follows:

Code:
PRINT N'Creating [RemsdaqProgrammability].[ConvertDTToXML]'
GO
CREATE FUNCTION [RemsdaqProgrammability].[ConvertDTToXML] (@dt [datetime])
RETURNS [nvarchar] (0)
WITH EXECUTE AS CALLER
EXTERNAL NAME [Remsdaq.C5.NotificationSender].[Triggers].[ConvertDTToXML]
GO

Note the (0) length return parameter

3) A trigger is scripted to be alteredwithout the fully qualified name being used which is resulting in failure. e.g.
Code:
ALTER TRIGGER [ObjectCondition_U2]
   ON  [RemsdaqTables].[ObjectCondition]
   AFTER UPDATE
   NOT FOR REPLICATION
AS

should be including [RemsdaqTables]. in front of the Trigger name and for some reason is not.

Any ideas for these problems?

On the whole, the packager software seems ideal for our use, but obviously until i can get an upgrade to work successfully i can not recommend it. Therefore any assistance in these matters would be greatly appreciated.

Regards,

Simon Davis.
Back to top
View user's profile Send private message
Ben Pinchen



Joined: 28 Dec 2006
Posts: 157
Location: Red Gate

PostPosted: Mon Jul 14, 2008 4:06 pm    Post subject: Reply with quote

Hi, I'm sorry that you're experiencing these issues with SQL Packager. SQL Packager 5.4 uses the SQL Compare 5 engine to compare and parse the database objects. There were a few issues with assemblies in the SQL Compare engine and I know that a lot of these issues have been resolved in the newest SQL Compare engine (version 7).

SQL Packager 5.5 is due for release on Monday 21st July and has been built to utilize the latest SQL compare engine. Would you be able to download this version of SQL Packager, when it is released next week, to see if it resolves the issues?

Please let me know if you do still experience issues after trying this latest version.
Back to top
View user's profile Send private message
sidetnee



Joined: 07 Jul 2008
Posts: 2

PostPosted: Tue Jul 29, 2008 4:19 pm    Post subject: Reply with quote

Just a follow up post to confirm that having downloaded and tried the latest version of Packager, the problems previously experienced do appear to have been fixed. The evaluation continues.....
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group