DacFX does not generate the OBJECT_ID property for CREATE USER
- Dominant language
- C#
- Stars
- 460
- Forks
- 29
- Avg merge
- 4d 9h
- Merged PRs (30d)
- 7
Description
- SqlPackage or DacFx Version: 16.18089.0
- .NET Framework (Windows-only) or .NET Core: 4.8.09032
- Environment (local platform and source/target platforms): (local)
**Steps to Reproduce:**
1. Create a project, create a user object having the OBJECT_ID option in the EXTERNAL flavour of the principal.
2. Build the project (Works)
3. Create a deployment script for the database and inspect the script. => The script will omit the OBJECT_ID part.
The ScriptDom implemented the parsing, thought he DacFX does not have to logic so far.
*Found by Jenss*
*Validated by ZijChen*
**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 by reproducing the CREATE USER case in DacFx or SqlPackage using an external principal with OBJECT_ID, then inspect the generated deployment script. Compare the project definition with the script output and use ScriptDom as the parsing reference; done means the OBJECT_ID option is preserved in the deployment script.
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
- 45/100