Schema Comparison Update script misses the Schema out from all objects
Posted: 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
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
