During the last few years I’ve been involved in database source control management and release plans tasks. These are important and (mostly) underestimated topics.
You can implement source control management in many different ways
- Visual Studio and TFS/SVN/GIT/..
- Direct integration with source control tools and filesystem
- Sql Server Management Studio integrated with TFS/SVN/GIT/..
- Database backups
IMHO, putting databases under source control management should be mandatory for every team.
In this post, I will try to explain how SQL Server Management Studio can cooperate with one of the third party tools that I’m currently using. This is the scenario: