3

Everyone, I'm looking on a way to deploy updates to our on prem databases using Azure DevOps and I'm running into a roadblock on the release definition. I have my DACPAC ready to go, but not sure how to get that over to my on prem server.

I see the WinRM-SQL Server DB Deployment as a task, but not sure how to set that up. I have seen a couple of videos that use the SQL Server Database Deploy as an option, but it looks like that task has been deprecated, so it looks like I will need to use the WinRM-SQL task. So, could anyone point me in the right direction on how to set this task up to use my local SQL server or possibly a tutorial that help get me started?

Improve this question
1
  • Any luck finding a solution? I am just now looking into this for our pipelines. Commented Jan 14, 2019 at 22:54

2 Answers 2

Reset to default
3

You will also have to install a release agent on the target server where you will be deploying the database, assign it to a Deployment Group, create your release pipeline template and then run a release. I wrote a blog post about how to deploy a database to an on-prem SQL Server by leveraging Azure DevOps: https://jpvelasco.com/deploying-a-sql-server-database-onto-an-on-prem-server-using-azure-devops/

Hope this helps.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

If you already created a Deployment Group, within your Pipeline:

  1. Click to Add a new stage: [1]: https://i.sstatic.net/vc5TI.png
  2. On the right side, (SELECT A TEMPLATE screen) type SQL in the search box
  3. Select: IIS website and SQL database deployment, this will add a Stage with Two tasks: IIS deployment and SQL DB Deploy.
  4. Delete the IIS Deployment Task
  5. Configure the SQL DB Deploy task - It does not say it is deprecated.
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.