How can we improve SQL Source Control?

Commandline Source control

It would be great if we could integrate SQL Source Control with our build scripts. For example a simple command line command to get the latest changes and apply (or script) them to our staging environment would be great. Or a command to commit all changes to source control.

5 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • saul commented  ·   ·  Flag as inappropriate

        David, are there any examples on how to do this, in particular our use case is the following:

        A vendor deploys a database every day in a particular server, then we get the schema out of this database, and have to manually alter our local database (the one that is linked to SQL Source Control) and commit all changes, then push these commits to Github (also using SQL Source control and or Git bash), how can we do the commit part using cmdlets?, I guess that I could make the database changes to my local following the same steps we do for any release to an environment, however I'm unable to find an example on how to commit these changes to my sql source control working directory :)

      Feedback and Knowledge Base