search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 896 forks source link

Unexcludable elements in schema compare should show without a checkbox #21035

Open kisantia opened 1 year ago

kisantia commented 1 year ago

SSDT shows unexcludable differences without the checkbox: image

Right now in ADS, they aren't shown at all in schema compare because they get filtered out here: https://github.com/microsoft/sqltoolsservice/blob/6f198e9e5aacc0e1a8eacb3ad07b556e0cbe3d52/src/Microsoft.SqlTools.ServiceLayer/SchemaCompare/SchemaCompareOperation.cs#L117

kisantia commented 1 year ago

Repro: Project1: one table Project2: script with:

CREATE USER [testUser] WITHOUT LOGIN;
GO

ALTER ROLE [db_datareader] ADD MEMBER [testUser];
GO

Schema compare with Project1 as source and Project2 as target