Dependency Problems

miro

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.

Brian Donahue

Thanks for asking. Is this a new database package or an upgrade package?

miro

This is a new package... I'm just trying to do structure only, no data.

Brian Donahue

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.

jimboh

suggest you may have a collation or case sensitivity issue

miro

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?

Brian Donahue

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.