Dependency fail

[nnodari]

Hi,

In Upgrade Database option for SQL Packager 6.4.0.8 some stored procedures are created/changed before table changes, causing dependecy error. Even with include dependencies checked.

How to fix ?

Server: SQL Server 2005 SP4.

Regards!
_________________
Att

[james.billings]

IncludeDependencies just means that objects you didn't select when creating your package will be automatically selected if they are detected as dependencies of other objects.

In your case, it sounds more like SQL Packager isn't able to determine the correct order for some reason, and this can occur if there is an effectively circular chain - so for instance if the SP references a column in a table, then normally the table would be scripted first, but if the table has a computed column that somehow then refers back to the SP, the correct ordering cannot be determined.
Can you reproduce the same thing on an earlier release, while using the same database at all?

[nnodari]

What do you mean with earlier release ? Like SQL Server 2008 SP1 ?

Att

[james.billings]

I meant an earlier release of Packager - for instance ftp://support.red-gate.com/patches/SQL_Packager/SQL%20Packager_6.0.1.9.zip

If that doesn't help, then we'd probably need the databases here to try and see if we can spot the problem.

[nnodari]

we fix. thanks.
_________________
Att