How to Get an Azure SQL Database into Git with SQL Change Automation in Azure DevOps

preview_player
Показать описание
In this video, Redgate's Kendra Little creates a new SQL Change Automation project, then uses it to baseline an existing Azure SQL Database. The database code is commited and pushed to a fresh Git repository in Azure DevOps.
Рекомендации по теме
Комментарии
Автор

So why give it the shared DEV database? Don't you want individual developers working on their own local db instances so they can separately code against those?

Also, I can't quite figure out how you are supposed to push both db and source code at the same time using your tooling so that I can activate my CI pipeline and do code tests against an expected database (again, not the shared DEV database).

Can you explain how this stuff is to work with code and not just databases/sql scripts?

Christobanistan
visit shbcf.ru