Schema Comparison Update script misses the Schema out from all objects

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
FifeCollegeAndy
Posts: 1
Joined: Thu 11 Nov 2021 13:30

Schema Comparison Update script misses the Schema out from all objects

Post by FifeCollegeAndy » Thu 11 Nov 2021 13:47

Hi,
I'm not sure if this is a setting i have wrong or a bug in the application but when i use the schema compare the update script that is generated for any changes does not reference the objects' Schema but the change window does

Example.. After comparison when i look at any changes that will be made i see something like this in the change window for an individual object :

CREATE TABLE [MYSCHEMA_USER].[TableName] (
[MyColumn] [varchar](10) NOT NULL
)
ON [PRIMARY]
GO

But the actual Schema Update script is generated as
CREATE TABLE [TableName] (
[MyColumn] [varchar](10) NOT NULL
)
ON [PRIMARY]
GO


Which creates new tables belonging to dbo.

Can anyone please shed any light on why this happens as i'm needing to run SQL compare on a DB with over 500 objects not belonging to dbo

Thanks

Andy

alexa

Re: Schema Comparison Update script misses the Schema out from all objects

Post by alexa » Fri 12 Nov 2021 19:05

You may need to unselect the following option Image

Post Reply