Creating DB from TFS script

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Creating DB from TFS script

Postby Agile_World » Thu Feb 14, 2013 10:01 pm

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!
Posts: 2
Joined: Wed Dec 19, 2012 2:52 pm

Postby james.billings » Mon Feb 18, 2013 2:19 pm

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
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests