Options
Dependent View Alter happens before Create Table
racinlfg
Posts: 3
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
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
Comments
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.
Thanks.