Scheduling sync between SQL Server database and TFS

renjithseban

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

Sergio R

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,