Managing Drift in Automated Deployments to SQL Server Databases
Category:
devops-automation
, sql-server
One big gotcha that teams often encounter when automating deployments for databases is that it’s difficult (or sometimes impossible) to ensure that all changes to the production database are performed through the automation pipeline.
These out-of-band changes case the production database to “drift” away from the schema as defined in version control.
