SQL Source Control 3 And Changelog Database Move From TEMPDB

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

SQL Source Control 3 And Changelog Database Move From TEMPDB

Postby alewis_usbtx » Mon Feb 11, 2013 6:11 pm

I have following the following post at:
http://www.red-gate.com/supportcenter/c ... ng_changes

I ran the script which does generate a new DB(CHANGELOG),I updated the xml config file(with applications closed) per the article.File:RedGate_SQLSourceControl_Engine_EngineOptions.xml is saved with the new info,however this file is always overridden with the orig info and the table RG_AllObjects is never generated in the new CHANGELOG database...
SQL SERVER 2008 R2

Any thoughts???
alewis_usbtx
 
Posts: 1
Joined: Mon Feb 11, 2013 6:06 pm

Postby james.billings » Tue Feb 12, 2013 7:26 pm

In case anyone else stumbles across this- we established that if the config file is invalid, then it'll get replaced with the 'last good' copy at startup. The web-page documenting the change looks to currently have an error in the comment-block of the XML so copying it exactly will lead to this problem.

My current working file looks like this:

Code: Select all
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<EngineOptions version="3" type="EngineOptions">
  <TraceCacheDatabase>CHANGELOG</TraceCacheDatabase>
</EngineOptions>
james.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby andym » Mon Feb 25, 2013 3:18 pm

hi, I have just noticed this post after posting the same problem today.

We need to direct source control to a dedicated changelog as well as edit the polling time with :

<DefaultTraceMinimumInterQueryTimeInMillis>60000</DefaultTraceMinimumInterQueryTimeInMillis>

I assume these tags will be within the <engineoptions> tag too? i.e end result =

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


Is this possible to confirm? Thanks
andym
 
Posts: 8
Joined: Mon Jan 28, 2013 1:48 pm

Postby andym » Mon Feb 25, 2013 3:29 pm

Just to add, We have tested my last post and XML appears to work fine on our PCs, maybe worth confirming from redgate staff for clarity however.
andym
 
Posts: 8
Joined: Mon Jan 28, 2013 1:48 pm

Postby andy.campbell.smith » Wed Feb 27, 2013 3:19 pm

Hi Andy - you're absolutely correct. The config file you posted will make the following changes:

- Attempt to store changelog information in a database called CHANGELOG, if it exists
- Set the polling interval to 60 seconds

Is that what you were hoping to achieve?
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests