Dependent View Alter happens before Create Table

racinlfg

We have an existing view that has been altered to include a brand new table. When I use SQL Packager the script that is created puts the create table statement after the alter view statement.

I've tried to do the same process using SQL Compare (with the dependencies checkbox checked) and get the same result. ([208] Invalid object name 'productConfig.dbo.tdbGroup'.) The CREATE statement for this table is later in the change script.

We just purchased our licenses and are using version:
SQLCompare 4.1.0.59
SQLPackager 4.1.0.78

How can I reorder these statements?

Thanks

Brian Donahue

Hello,

Is the productConfig database the same database name that you had created the package against? I'm aware that there can be some dependency parsing problems when comparing objects that are qualified up to the database-level and I think that's the issue here.

racinlfg

Yep...and taking the hint from your reply, I removed the reference and it works now.

Thanks.

Brian Donahue

Great, thanks for letting us know it's okay.