Red Gate forums :: View topic - Automatically commit daily?
Return to www.red-gate.com RSS Feed Available

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

Automatically commit daily?

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nickwang



Joined: 21 Nov 2011
Posts: 1

PostPosted: Mon Nov 21, 2011 11:03 pm    Post subject: Automatically commit daily? Reply with quote

Is it possible to schedule the sql source control to commit the changes of the databases daily? Is there any command line tools?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu Nov 24, 2011 11:12 am    Post subject: Reply with quote

Thanks for your post.

There isn't a command line or API for SQL Source Control, but as a workaround you could commit the working copy that SQL Source Control uses using a different client.

To find the working copy, press shift+right-click on the 'linked to path' on the setup tab. This folder contains all the changes, so you should be able to automate a commit of this folder. I haven't tested this before, so I can't guarantee there won't be problems.

The idea with SQL Source control is that the developer will commit the change when they're happy with the work, rather than a scheduled commit when the object might not be in a consistent state.

I hope this helps.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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