Automatically commit daily?

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

Automatically commit daily?

Postby nickwang » Mon Nov 21, 2011 10: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?
Posts: 1
Joined: Mon Nov 21, 2011 9:51 pm

Postby Chris Auckland » Thu Nov 24, 2011 10: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 Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests