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
• misc..

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:

• Red-Gate SQL Source Control as a source control tool (SSMS plugin)
• Team Foundation Service as a source control server (cloud TFS service)
• A simple SQL Server database
• SQL Server Management Studio as a database management IDE