Scheduling sync between SQL Server database and TFS

renjithsebanrenjithseban Posts: 2
edited December 16, 2016 9:42AM in SQL Source Control
Hi Team,

I'm planning to use RedGate SQL Source Control to keep the latest production scripts in TFS. I would like to know if we can schedule the sync action between database and TFS so that the sync operation is automated.

Suppose, I have scheduled the sync to happen on every Sunday at 12.00 AM, then the latest scripts from PROD databases get automatically updated in configured TFS location. So from user perspective we no longer need to worry about any manual action required to make the TFS up-to-date.

Can you please confirm if any such feature is available in Redgate SQL Source Control?

Thanks,
Renjith

Comments

  • Hi,

    In SQL Source Control committing to the repository is only possible interactively through SSMS, so I am afraid that the short answer to your question is no.

    We recommend that developers commit straight away after changing an object.

    Thank you,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.