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

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

Dependency fail

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nnodari



Joined: 30 Mar 2009
Posts: 19

PostPosted: Wed May 11, 2011 7:00 pm    Post subject: Dependency fail Reply with quote

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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1120
Location: My desk.

PostPosted: Thu May 12, 2011 8:27 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
nnodari



Joined: 30 Mar 2009
Posts: 19

PostPosted: Fri May 20, 2011 3:00 pm    Post subject: Reply with quote

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

Att
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1120
Location: My desk.

PostPosted: Fri May 20, 2011 3:03 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
nnodari



Joined: 30 Mar 2009
Posts: 19

PostPosted: Thu Jun 02, 2011 8:48 pm    Post subject: Reply with quote

we fix. thanks.
_________________
Att
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