Automatically commit daily?

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

Automatically commit daily?

Postby nickwang » Mon Nov 21, 2011 11:03 pm

Is it possible to schedule the sql source control to commit the changes of the databases daily? Is there any command line tools?
nickwang
 
Posts: 1
Joined: Mon Nov 21, 2011 10:51 pm

Postby Chris Auckland » Thu Nov 24, 2011 11:12 am

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests