How do you choose a source control system for your SQL Server database

If you already have a source code repository for your app code or other databases or you have another team that uses source control then just use theirs.

If you don't then use whatever the members of your team have used most, they all basically do the same thing and having your database under source control is a million times better than not having it under source control.

There is an exception, if you use visual source safe and I know people do still use it then use something else, it hasn't had a release in over 10 years and in my opinion is no longer fit for purpose, especially when you consider the other free options available to you.



October 9, 2015 - 15:52

I am currently going through

I am currently going through the process of assessing the benefits of difference SCM's for databases.

As we are starting pretty much from scratch, we are looking to features such as branching, tagging and 3rd party support to inform our decision. Having used git previously, I'm very tempted to go for a cloud hosted git solution (such as bitbucket) as this removes the worst of the complexities whilst keeping the benefits ;)

My biggest challenge is working out the extent we will use some of the more advanced features and selling my colleagues on the benefits of git!