2

I've read the following question: How to handle users and logins in Visual Studio Database Project?

Basically, I'm looking for a way to easily setup the logins based on the database server that's being deployed to. The additional catch is that this will be deployed as part of an azure-devops release pipeline and therefore will be deploying the dacpac.

The question linked aboved deals with VS 2010 and is rather manual. Has this changed at all? Can this be done using DAC Publish Profiles?

sr28
  • 4,728
  • 5
  • 36
  • 67

1 Answers1

0

Not much has changed by now, this may be one area in which SSDT lacks. You'll need to build out your permissions and users differently. It's already well documented in Peter Schott's blog.

Besides, it's not hard to deploy on multiple environment/servers with Azure DevOps Release pipeline under a single logins.

There is a concept called Deployment groups in Azure DevOps.

More details about this part, please take a look at here: Build and Deploy to multiple IIS servers and SQL Server using Azure DevOps

PatrickLu-MSFT
  • 49,478
  • 5
  • 35
  • 62
  • 1
    Presumably this can be handled by simply controlling which permission scripts to run based on a DAC publish profile a bit like this: https://stackoverflow.com/questions/35174045/how-to-run-different-pre-and-post-ssdt-pubish-scripts-depending-on-the-deploy-pr – sr28 Aug 14 '19 at 09:46