Creating DB from TFS script

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

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Creating DB from TFS script

Postby Agile_World » Thu Feb 14, 2013 11: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!
Agile_World
 
Posts: 2
Joined: Wed Dec 19, 2012 3:52 pm

Postby james.billings » Mon Feb 18, 2013 3: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
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests