How can we improve SQL Source Control?

Create the database from scratch

Instead on relying on the user to create the database and all the file groups, files and getting the collation correct, source control should do this for the user. it could perhaps prompt for a file location to put all the files but if I've gone through the effort of making file groups and sizing my files just right, I want those changes to be kept!

25 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Philip FlynnPhilip Flynn shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    ash flynnash flynn shared a merged idea: Open a Database FROM source control  ·   · 

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Sidharth NayyarSidharth Nayyar commented  ·   ·  Flag as inappropriate

        I agree with John. We can use sqlcompare through command prompt to do continuous integration but the missing piece is the creation of the database. If this was also stored in source control then continuous integration should have the option to also create a new database.

      • John FuexJohn Fuex commented  ·   ·  Flag as inappropriate

        I think it ought to script the database itself and let you store that in source control. Then it would be able to create the DB completely from source control.

      Feedback and Knowledge Base