Auto synch to source control (SQL Source control)

nettium

Hi,

Currently, we need to manual click the Commit button  to synch  the changes to source control  (TFS)

I would like to check is there a way auto synch to source control can be done once script deployed to database.

we have incident that developer checked in the old script in source control
  

AlexYates

That is not how SQL Source Control is designed to work. It sounds like what you want is DLM Dashboard?
www.red-gate.com/products/dlm/dlm-dashboard

Technically, there are things you can do. For example, you could write a script to run SQL Compare to sync a Dev database with a scripts folder and check those scripts into source control. Then you could run that script on a schedule or following a DDL trigger.  However, I've not yet seen a scenario where that's been a wise choice.

Sergio R

I agree with Alex.

I'd also recommend refreshing the Get Latest tab before working on any changes, to make sure that you are working on an up to date schema.