Advertisements

#redgate sql source control

So, had the need of source controlling our views and sprocs (who doesn’t)

We have been trying various methods using one of the billion versions of team foundation server etc. etc.

So decided to try Red Gate Sql Source Control, and use subversion as the back end.

So first off I needed a server spun up…. so time to update my server 2008 template… please wait… ok an hour later got it all patched up. Next I needed Subversion

http://www.visualsvn.com/server/features/#easy-install

I’ve never messed with this one before but it says easy install so I will give it a try!

Ok, installation took about 30 seconds… so far I like it! Ok made a repository and started following instructions here

http://www.databasejournal.com/features/mssql/article.php/3890406/Red-Gate-SQL-Source-Control-a-Simple-and-Elegant-Solution-That-Works.htm

Started downloading a 28 day trial of sql source control

So installed and then linked it to our database. I was too quick as a bunny and didn’t wait for it to sync up. But after it has recorded all the objects then you commit all the objects as new!

This stuff works great, and only took < 1 hour to setup! Awesomesauce

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: