Creating DB from TFS script

Agile_WorldAgile_World Posts: 4
edited February 18, 2013 9:19AM in SQL Source Control Previous Versions
Hello All,

I am new in Red Gate world. I linked my DB to TFS using sql source control 3.0. I want to know if I can create any DB using TFS DB script.

Thanks ahead!
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    Thanks for your post.

    If you linked your DB to TFS and you committed everything, then you now have a load of .SQL files in your TFS repo that represent the database.

    You can use SQL Compare to synchronize from this to a blank database, effectively making a copy.

    For a more complete solution you can incorporate our tools with full end to end deployment all the way from SQL Source control through test and to deploying out to the final environment. It's a big subject though, but I'd start by reading over the white papers here
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.