-
Notifications
You must be signed in to change notification settings - Fork 25
Closed
Labels
bugSomething isn't workingSomething isn't workingfixed-pending-releaseFix in upcoming releaseFix in upcoming release
Milestone
Description
- SqlPackage or DacFx Version: 162.5.57
- .NET Framework (Windows-only) or .NET Core: both
- Environment (local platform and source/target platforms): all
Steps to Reproduce:
- Create a sqlproj with this script:
CREATE TABLE [dbo].[Table1]
(
[Id] INT NOT NULL PRIMARY KEY,
[Name] NVARCHAR(50) NOT NULL,
[Price] DECIMAL(18, 2) NOT NULL,
[Description] NVARCHAR(255) NULL
)
GO
CREATE NONCLUSTERED INDEX [IX_Table1_Name_Price] ON [dbo].[Table1] ([Name], [Price])
GO
ADD SENSITIVITY CLASSIFICATION TO [dbo].[Table1].[Price]
WITH (
LABEL = 'Confidential',
INFORMATION_TYPE = 'Financial',
RANK = HIGH
);
GO- Publish to a database
- Change the sensitivity classification above (for example:
RANK = HIGHtoRANK = CRITICAL) - Publish/generate script to the database again. The script will contain steps to DROP INDEX, make the sensitivity classification change, before recreating the index.
Workaround
Workaround at this time is to set IgnoreSensitivityClassifications to true during publish and make the sensitivity classification changes manually in the database.
Did this occur in prior versions? If not - which version(s) did it work in?
(DacFx/SqlPackage/SSMS/Azure Data Studio)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't workingfixed-pending-releaseFix in upcoming releaseFix in upcoming release