microsoft / microsoft/DacFx

DacFX does not generate the OBJECT_ID property for CREATE USER

Open
#436 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: 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)
1
3
2

Contributor guide

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.