What are the challenges you face when working across database platforms? Take the survey

Auto synch to source control (SQL Source control)


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


  • Options
    AlexYatesAlexYates Posts: 264 Rose Gold 2
    That is not how SQL Source Control is designed to work. It sounds like what you want is 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
    Creator of Speaking Mentors
    Microsoft Data Platform MVP
    Friend of Redgate
    Twitter / LinkedIn
  • Options
    Sergio RSergio R Posts: 610 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.
    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.