Dependency fail

nnodarinnodari Posts: 24
edited June 2, 2011 3:48PM in SQL Packager Previous Versions
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
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    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?
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • nnodarinnodari Posts: 24
    What do you mean with earlier release ? Like SQL Server 2008 SP1 ?

    Att
    Att
    · Share on Twitter
  • James BJames B Posts: 1,124 Silver 4
    I meant an earlier release of Packager - for instance ftp://support.red-gate.com/patches/SQL_ ... .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.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • nnodarinnodari Posts: 24
    we fix. thanks.
    Att
    · Share on Twitter
Sign In or Register to comment.