CLR Dependancies

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

CLR Dependancies

Postby sidetnee » Mon Jul 07, 2008 11:27 am

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: Select all
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: Select all
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.
sidetnee
 
Posts: 2
Joined: Mon Jul 07, 2008 11:13 am

Postby Ben Pinchen » Mon Jul 14, 2008 4:06 pm

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.
Ben Pinchen
 
Posts: 157
Joined: Thu Dec 28, 2006 1:21 pm
Location: Red Gate

Postby sidetnee » Tue Jul 29, 2008 4:19 pm

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.....
sidetnee
 
Posts: 2
Joined: Mon Jul 07, 2008 11:13 am


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest