Auto synch to source control (SQL Source control)

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
  


Answers

  • AlexYatesAlexYates Cambridge, UK Posts: 261 Rose Gold 2
    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.
    Alex Yates
    DevOps Mentor and Coach

    Director of DLM Consultants and Data Relay
    Creator of Speaking Mentors
    Microsoft Data Platform MVP
    Friend of Redgate
    Twitter / LinkedIn
  • Sergio RSergio R Posts: 582 Rose Gold 5
    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.
    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.