Schema Compare retains the sensitivity classifications when table is deleted

Riyaz Barkatali Budhwani 0 Reputation points
2024-03-12T01:15:01.6966667+00:00

Hi,

We've got a sql project that we use for CICD deployments from DEV to TST/PRD.

Recently we had added some classifications to the tables in DEV as we were trialling purview.

During schema compare and update to the solution repo, I have noticed that the project retains the classification despite the table being deleted. This results in the project build failing. I have recreated the table with classification, and the project builds fine. I then proceeded to remove the classifications (retained table) and updated the target repo. The project builds fine. While deployment, I noticed that the classifications were retained and the solution deployed. Basically the classifications have been deleted from source but retained in target. We are in the process of changing some data load patterns (batch to incremental and vice versa) to optimise costs.

Is this a limitation on the Visual Studio side or am I missing something?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,558 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,589 questions
0 comments No comments
{count} votes