Scheduling sync between SQL Server database and TFS
renjithseban
Posts: 2
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
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
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,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools