Schema bound and encrypted views cannot be updated
- 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
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