a blog for those who code

Friday 21 October 2016

Redgate SQL Source Control for better Database Version Control

In this post we will be discussing about getting started with Redgate SQL Source Control. Redgate SQL Source Control connect your database to the version control system (SVN, Git, Team Foundation Server etc). The best part of this software is that it plugs into your SQL Server Management Studio and the changes can be easily visible through the Management Studio itself.

PC : https://www.red-gate.com/products/sql-development/sql-source-control/

The Key features of SQL Source Control involves :

1. Version control inside Management Studio
2. Version control schemas and reference data
3. Can view full history of changes
4. It handles referential integrity of your database.
5. It can push or pull git repository
6. Can roll back any changes you don't want
7. Can be used on shared database

You can start using Redgate SQL Source Control by downloading the 28-day free trial. Once installed you can see your management studio opening up with something like below:

 Using this you can select which database you want to link once you connected to the server. One thing to know that in dedicated model each developer will work on their own copy of databases whereas in shared model all developers work on same databases. When linking it will ask you how would you like to connect and the options are :

1. Link to my source control system - Use this if you want it only for dedicated servers
2. Link to working folder - Use this if you want to select dedicated or shared
3. Just let me try it out - Use this to know more about SQL Source Control

We will select Link to working folder and then select custom option which will allow us to specify the location of the working folder as well as allows us to select the config file for the source control system as shown below

You can easily see if the database is linked or not by the change of color from yellow to green.

Now whenever any one changes anything in the database be it addition of table, altering table, creating new stored procedure using this Cool little tool we can easily implement the version control system for our databases.

Please Like and Share the Blog, if you find it interesting and helpful.

No comments:

Post a Comment