2

Here is my scenario -

I have access to source Azure SQL Database where i did few changes to schema (eg adding a table). Now I want to deploy this SQL code to prod Azure SQL Database using Azure DevOps dacpac task.

Build pipeline - I have used MS Build task to generate .dacpac file

Release pipeline - I know Azure SQL server name and Database name but do not know Server admin credentials. How to deploy dacpac to the Prod target server? What are all the tasks required in Release pipeline to achieve this and it should be repeatable process.

Any help would be really appreciated

  • If it's a security thing you could get the credentials put into a KeyVault then the deployment task can pull the credentials from KeyVault. That way you'll never know or need to know what they are. – Simon Mar 28 at 17:49
  • Thats right but everyday, there are lot of teams deploy into prod server and security team doesnt want to share the admin creds secrets with any one of Dev teams. This option is not possible – DevOps learner Mar 30 at 7:45
1

You either have to have the login information in order to connect to the database, or, you have to configure your database server to allow access to Azure Services. This means that the SQL Database and server and the Azure DevOps pipelines have to be part of the same account (not necessarily the same login, but Azure AD). I'd lean towards requiring the connection information rather than open up everything broadly between all your Azure services.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.