Creating DB from TFS script

[Agile_World]

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!

[james.billings]

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