question

LindgrenLars-8959 avatar image
0 Votes"
LindgrenLars-8959 asked Cathyji-msft commented

Sensitivity classification feature in SQL 2019

We have SQL Database projects with Target platform “SQL Server 2019 (and in addition Azure SQL databases managed instance” in VS2019 for some our databases).
We regularly deploy database code via Azure YAML multistage deployment pipelines using MSBuild publish, that uses Schema compare feature.
Recently we started to use new Sensitivity classification feature in SQL 2019 Server and have classified about 20 000 columns in one database.
After adding that to code, MSBuild.exe which builds our project, started to run dramatically longer – 3h, after some optimization (added MSBuild arguments -m /p:CmdLineInMemoryStorage=TRUE ) – 1 h. If we do not store classifications in code, lines are dropped from database in every deployment.
The one thing, that could help us is Ignore or DoNotDrop key in database.publish.xml configuration file , that we use , for example for logins we have row like <DoNotDropLogins>True</DoNotDropLogins>.

In this case we could store classifications in separate script, that is not analyzed during build.
We tried to find appropriate flag for Sensitivity classification in Microsoft.Data.Tools.Schema.SqlTasks.targets file, but did not succeeded.
Will that exists, but not documented? Or do we need to find other approach?

Hope anyone can help us,

Br Lars

sql-server-general
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @LindgrenLars-8959,

Your description environment related to VS, but I am not familiar with VS. I know how to add sensitivity classification in SSMS for SQL server. I search this from google, but did not find any documents related to this question. I need more time to research this question. Or suggest you adding the related tag in this topic, such as VS-general, or other tags that related to this issue, then people from different product team could help you better.

1 Vote 1 ·

Many thanks for reply!

I have add the tag you suggested.

Br Lars

0 Votes 0 ·

Hi,

It seems you did not add the tag successfully. Suggest you edit the tag again as below.
122557-screenshot-2021-08-12-105246.jpg


0 Votes 0 ·

0 Answers