Red Gate forums :: View topic - SQL Source Control 3 And Changelog Database Move From TEMPDB
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

SQL Source Control 3 And Changelog Database Move From TEMPDB

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
alewis_usbtx



Joined: 11 Feb 2013
Posts: 1

PostPosted: Mon Feb 11, 2013 6:11 pm    Post subject: SQL Source Control 3 And Changelog Database Move From TEMPDB Reply with quote

I have following the following post at:
http://www.red-gate.com/supportcenter/content/SQL_Source_Control/knowledgebase/Logging_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???
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Tue Feb 12, 2013 7:26 pm    Post subject: Reply with quote

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:
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<EngineOptions version="3" type="EngineOptions">
  <TraceCacheDatabase>CHANGELOG</TraceCacheDatabase>
</EngineOptions>
Back to top
View user's profile Send private message
andym



Joined: 28 Jan 2013
Posts: 8

PostPosted: Mon Feb 25, 2013 3:18 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
andym



Joined: 28 Jan 2013
Posts: 8

PostPosted: Mon Feb 25, 2013 3:29 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Wed Feb 27, 2013 3:19 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group