microsoft / microsoft/DacFx

SqlPackage publish fails with removed column data masking function

Open
#82 0 comments 0 reactions 1 assignee Claimed by @ssreerama View on GitHub
area: deployment bug sqldw triaged
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

- SqlPackage or DacFx Version: Latest Version
- .NET Framework (Windows-only) or .NET Core: Both
- Environment (local platform and source/target platforms): All (tested on Azure Synapse SQL Pool Database)

**Steps to Reproduce:**

1. Created SQL pool database and created a table with masked column and inserted data.
2. Using VS2019 created SQL DB Project from the database.
3. Updated the table script by removing the masked function and add a new column and built the project.
4. Using SqlPackage FULL/CORE version and publish the generated dacpac to the SQL pool db.
![image](https://user-images.githubusercontent.com/74571829/156964736-4780572b-abfd-45ed-ba27-f977cea12c47.png)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.