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

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

Dependency Problems

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
miro



Joined: 06 Sep 2007
Posts: 3
Location: Charlotte, NC

PostPosted: Thu Sep 06, 2007 6:58 pm    Post subject: Dependency Problems Reply with quote

Hi,

I'm just trying to create a structure only copy of my database, but when I try to execute the packager file, I get errors when the package attempts to create a view (Invalid object name [TableName]). In looking at the generated scripts, it appears that the view is being created before the tables, which obviously isn't going to work.

I am a first-time user, so I don't think I have set any options differently or changed anything about the prgram (not intentionally). I can't find any options to control the order of execution, but I can't seem to be able to get a simple pass to work properly... any thoughts would be greatly appreciated.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6647

PostPosted: Fri Sep 07, 2007 9:15 am    Post subject: Reply with quote

Thanks for asking. Is this a new database package or an upgrade package?
Back to top
View user's profile Send private message
miro



Joined: 06 Sep 2007
Posts: 3
Location: Charlotte, NC

PostPosted: Fri Sep 07, 2007 5:44 pm    Post subject: Reply with quote

This is a new package... I'm just trying to do structure only, no data.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6647

PostPosted: Fri Sep 07, 2007 5:46 pm    Post subject: Reply with quote

Where TableName appears in the view, is the object fully-qualified? If it contains the name of the database, it may not be being picked up as a dependency. For instance MyDB.DBO.TableName.
Back to top
View user's profile Send private message
jimboh



Joined: 29 Jan 2007
Posts: 17
Location: Melbourne Australia

PostPosted: Thu Sep 27, 2007 1:06 pm    Post subject: Reply with quote

suggest you may have a collation or case sensitivity issue
Back to top
View user's profile Send private message
miro



Joined: 06 Sep 2007
Posts: 3
Location: Charlotte, NC

PostPosted: Tue Nov 06, 2007 7:39 pm    Post subject: Re: Reply with quote

Brian Donahue wrote:
Where TableName appears in the view, is the object fully-qualified? If it contains the name of the database, it may not be being picked up as a dependency. For instance MyDB.DBO.TableName.

No, in the specific example I am looking at the view is referencing just the table name, with no owner or database name specified. Is this the issue?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6647

PostPosted: Wed Nov 07, 2007 10:05 am    Post subject: Reply with quote

I don't think that would cause a problem to exclude the owner name as far as the dependencies go.

I don't know what is happening here. I think it would be necessary to see the SQL scripts for these two objects.
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