How can we help you today? How can we help you today?

Automatically commit daily?

Is it possible to schedule the sql source control to commit the changes of the databases daily? Is there any command line tools?
nickwang
0

Comments

1 comment

Sort by
  • Chris Auckland
    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
    0

Add comment

Please sign in to leave a comment.