Auto synch to source control (SQL Source control)

nettium · March 7, 2019 6:33AM

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

Image: https://us.v-cdn.net/6029854/uploads/editor/kw/f9pcb22bldz3.png

AlexYates · March 7, 2019 1:15PM

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 · March 8, 2019 1:51PM

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.

Auto synch to source control (SQL Source control)

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk