Dependency fail

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Dependency fail

Postby nnodari » Wed May 11, 2011 7:00 pm

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
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm

Postby james.billings » Thu May 12, 2011 8:27 pm

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?
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby nnodari » Fri May 20, 2011 3:00 pm

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

Att
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm

Postby james.billings » Fri May 20, 2011 3:03 pm

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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby nnodari » Thu Jun 02, 2011 8:48 pm

we fix. thanks.
Att
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 1 guest