When you're using SqlPackage.exe to deploy a .dacpac to Azure, you must have access to the 'master' table in order for the tool to retrieve information necessary to create a diff of the database and deploy the differences during the Publish action.
For that reason, you need the 'sa' account, because simply having 'db_owner' on the Azure database is not sufficient.
No comments:
Post a Comment