0

When I try to create a DACPAC file for my source database the SQL user permissions present in the source database is not getting included. Whenever I deploy the source database DACPAC file to target database the entire schema is getting created properly on my target database except the user permissions present in the source database. I have tried checking my source database DACPAC file by unpacking it and the user permissions are not included in the model file.

The script I am using to generate a DACPAC file from my source database is below :

sqlpackage /a:extract /of:true /ssn:tcp:test.database.windows.net,1433 /sdn:source_db /su:admin /sp:password /tf:"C:\SQL Server Management Studio\DAC Packages\source.dacpac";

The script I am using to deploy the source database DACPAC file to target database is below :

sqlpackage /a:publish /sf:"C:\SQL Server Management Studio\DAC Packages\source.dacpac" /tsn:tcp:test.windows.net,1433 /tdn:target_db /tu:admin /tp:password

Should I include some property in this ?

Vignesh Ramesh
  • 5
  • 1

3 Answers3

1

Just for now, the data migration with DACPAC file in Azure SQL database can't migrate the user and it's permission.

You need manually create the user or grant the user permission. There isn't a way can include the user permission.

Leon Yue
  • 15,693
  • 1
  • 11
  • 23
0

DACPAC does not have security objects as part of the DACPAC. We need to include the permissions as part of the post deployment script. I am giving example security activities as part of the post deployment script.

  1. Create Logins
  2. Create Users
  3. Create Roles
  4. Permissions to Roles, Users ...
Venkataraman R
  • 12,181
  • 2
  • 31
  • 58
0
sqlpackage /a:extract  /p:IgnorePermissions=false
Peter Csala
  • 17,736
  • 16
  • 35
  • 75
user17493998
  • 1
  • 1
    As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Nov 24 '21 at 07:29