SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
Sensitivity classification feature in SQL 2019
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 34%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Lindgren, Lars
1
Reputation point
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
{count} votes
-
CathyJi-MSFT 22,371 Reputation points Microsoft External Staff2021-08-11T08:04:18.023+00:00 Hi @Lindgren, Lars ,
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.
-
Lindgren, Lars 1 Reputation point
2021-08-11T08:52:33.48+00:00 Many thanks for reply!
I have add the tag you suggested.
Br Lars
-
CathyJi-MSFT 22,371 Reputation points Microsoft External Staff
2021-08-12T02:54:10.347+00:00 Hi,
It seems you did not add the tag successfully. Suggest you edit the tag again as below.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 89%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Aras0712 1 Reputation point2023-08-14T10:11:20.63+00:00 Has this been resolve?
I mean is thee a possibility to keep data classification without droping it?
Sign in to comment
Sign in to answer