Thursday, October 6, 2011

SQL Source Control

I'm sure there are others out there that have had this problem with their database. Here's the scenario:

With your code you have a nice code repository set up. You are able to check in code, get latest, merge code, keep a nice version history with comments, etc. but when it comes to the database, all of that is a little harder to manage. Maybe you keep your scripts in SVN, but then you have to modify them in SVN before you update the server, make sure it compiles, commit the script in SVN, etc. but it's not all in one neat little IDE as it is with your code. It takes a few more steps to get all of the benefits of having a code repository when it comes to dealing with the database.

In comes Red-Gate's SQL Source Control. We just downloaded the trial and started using it. Setup literally took five minutes, and now we're able to use source control directly in SQL Management Studio!! It's quite brilliant if you ask me.

Check out the link below and watch the funny animated video if you'd like a quick overview of how it all works.
http://www.red-gate.com/products/sql-development/sql-source-control/

*Here's a direct link to the promo video, which I thought was quite clever:
http://www.red-gate.com/products/sql-development/sql-source-control/assets/video/SQL-Source-Control-Animation2/SQL-Source-Control-Animation.swf

No comments:

Post a Comment