How can we improve SQL Source Control?

Generate a Script rather than Apply changes in the Get Latest tab

I am using GIT and SQL Source Control. After running "Pull from remote repository" in the Get Latest tab, the only option is to Apply changes which directly updates the database.

If the changes include something like the classic renaming of a column, it will drop the column and add a new one and I lose data.

I would like to be able to simply generate a script so I can review it and manually apply it rather than directly update the database.

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

    1 comment

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

        Also I know that if the apply changes fails, it prompts you to open the script. I'd like that to be an option initially.

      Feedback and Knowledge Base