search

microsoft / DacFx

DacFx, SqlPackage, and other SQL development libraries enable declarative database development and database portability across SQL versions and environments. Share feedback here on dacpacs, bacpacs, and SQL projects.
https://aka.ms/sqlpackage-ref
MIT License
313 stars 19 forks source link

DacFX does not generate the OBJECT_ID property for CREATE USER #436

Open JensKSuessmeyer opened 6 months ago

JensKSuessmeyer commented 6 months ago

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