Best way to perform CI/CD using a git repo and Azure Devops for SQL Server schema changes?

Michael MacGregor 86 Reputation points
2021-07-08T18:22:33.03+00:00

e are looking for the best way, whether cheapest or easiest or most reliable & robust, to do CI/CD with Azure Devops using a git repo.

We currently have some Redgate tools, SQL Change Automation, SQL Source Control, and SQL Compare, that we are looking at using for this purpose but a) it's costly and b) it's somewhat convoluted and finicky to setup.

Any help and advice would be most appreciated.

N.B. We have SQL 2019 installed on Azure VMs right now but will be looking to migrate to Azure SQL Database, or Azure SQL Managed Instance in the not-too-distant future.

TIA

Michael MacGregor
Database Architect

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,455 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Michael MacGregor 86 Reputation points
    2021-07-08T21:04:38.977+00:00

    That's five years old, the technology and options have changed since then.

    0 comments No comments