microsoft / microsoft/DacFx

Schema bound and encrypted views cannot be updated

Open
#662 0 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

- SqlPackage or DacFx Version: 170.0.94.3
- .NET Framework (Windows-only) or .NET Core: .net 8
- Environment (local platform and source/target platforms): N/A

**Steps to Reproduce:**

1. Extract and import the SQL Project
[TestProject.zip](https://github.com/user-attachments/files/20978314/TestProject.zip)
2. Publish the database.
3. Publish the database again to the same target.
- The view will be altered to remove the schema binding
- View cannot be altered, because the target column's don't match the initial View.

**Did this occur in prior versions? If not - which version(s) did it work in?**

(DacFx/SqlPackage/SSMS/Azure Data Studio)

Contributor guide

Open the contributing guide

Research direction

Start with the attached TestProject.zip and reproduce the issue using SqlPackage or DacFx 170.0.94.3 on .NET 8, publishing the database twice to the same target. Compare the view definition after each publish, focusing on schema binding and target-column matching. Done means the second publish can update the view without removing schema binding or failing because the columns no longer match.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.