| Author |
Message |
miro
Joined: 06 Sep 2007
Posts: 3
Location: Charlotte, NC
|
 Posted: Thu Sep 06, 2007 6:58 pm Post subject: Dependency Problems |
 |
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Fri Sep 07, 2007 9:15 am Post subject: |
|
|
Thanks for asking. Is this a new database package or an upgrade package?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
miro
Joined: 06 Sep 2007
Posts: 3
Location: Charlotte, NC
|
| Posted: Fri Sep 07, 2007 5:44 pm Post subject: |
|
|
| This is a new package... I'm just trying to do structure only, no data. |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Fri Sep 07, 2007 5:46 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
jimboh
Joined: 29 Jan 2007
Posts: 17
Location: Melbourne Australia
|
| Posted: Thu Sep 27, 2007 1:06 pm Post subject: |
|
|
| suggest you may have a collation or case sensitivity issue |
|
| Back to top |
|
|
miro
Joined: 06 Sep 2007
Posts: 3
Location: Charlotte, NC
|
| Posted: Tue Nov 06, 2007 7:39 pm Post subject: Re: |
|
|
| 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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Wed Nov 07, 2007 10:05 am Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
