Advertisements

#RedGate #SQLSourceControl Version 3.1

So, we recently upgraded to version 3.1 and things started going to heck in a handbasket. I guess with 3.1 a bunch of new stuff starts to get done in TEMPDB, anyways it was not playing vary nicely.

We backed the upgrade off. After more investigating it looks like you want to follow this procedure to create a CHANGELOG database

http://www.red-gate.com/supportcenter/content/SQL_Source_Control/knowledgebase/Logging_changes

After doing this, and editing RedGate_SQLSourceControl_Engine_EngineOptions.xml with the config line of

<?xml version=”1.0″ encoding=”utf-8″ standalone=”yes”?>
<!—->
<EngineOptions version=”3″ type=”EngineOptions”>
<DefaultTraceMinimumInterQueryTimeInMillis>60000</DefaultTraceMinimumInterQueryTimeInMillis>
<TraceCacheDatabase>CHANGELOG</TraceCacheDatabase>
</EngineOptions>

Things started being happy again.

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