SSDT and SQL Source Control are the two most widely used tools in Europe and North America for model-based source control and deployment of SQL Server databases.
I believe it’s important to use widely used and supported tools wherever possible. So what about alternative model-based solutions? To avoid getting tangled up in higher level debates about whether to adopt a migrations-based or a model-based source control solution – or even a hybrid, this blog post is specifically scoped to model-based source control solutions. I’ve written about the relative pros and cons here but the tl dr is that neither are perfect, both hold value, and generally you do need to pick one or the other. I hope this post will help you to decide which is more likely to suit you and your team.īut first… Why SSDT or SQL Source Control and not something else?įirstly, there are two styles of database source control and deployment: Model (aka “state”) and Migrations.
Now, dear reader, I’m going to review and compare the two most popular tools to help you put it all together: Microsoft SSDT/Visual Studio Database Projects and Redgate SQL Source Control.
Last year I delivered a session on GroupBy all about how to do Database DevOps right, and back in May I wrote a blog post for BOU about how to screw it up. My name’s Alex, and I care about databases, DevOps and data protection.
0 kommentar(er)
