Red Gate forums :: View topic - Newbie question: developer database setup
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Newbie question: developer database setup

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kiteason



Joined: 20 Jul 2011
Posts: 3

PostPosted: Wed Jul 20, 2011 9:45 am    Post subject: Newbie question: developer database setup Reply with quote

We're evaluating Redgate Tool belt with a view to integrating it with our TFS version control system.

We expect developers to work with local SQL databases, using SQL Compare to compare against a central repository in TFS and check in their changes.

We've succeeded in creating the set of scripts for the initial database schema and this is checked into TFS. My question is - how does a developer do their initial setup to create a local database whose schema is the same (initially) as the central repository scripts?

I can link a local database to source control, but then SQL Compare seems to think that it needs to delete all the tables etc. from the repository, rather than create them in the local database. It doesn't seem to be possible to do a 'Set as target' on a blank database then pick a source control repository as source. What am I missing?
Back to top
View user's profile Send private message
kiteason



Joined: 20 Jul 2011
Posts: 3

PostPosted: Wed Jul 20, 2011 9:59 am    Post subject: Reply with quote

Looks like the way to do this is to run SQL Compare stand alone, rather than trying to do this from SSMS. Then you can pick the scripts as the source and a blank database as the target.
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Jul 22, 2011 4:49 pm    Post subject: Reply with quote

Hi there,

Thanks for your post. Your best bet would be to pick a current version of the DB and then link that to a blank folder in TFS using SQL Source Control. Once you commit that into TFS using SQL Source Control, all your other developers an link up to the same root folder in TFS and perform a "Get Latest" using SQL Source Control, which will populate their blank DB's with the schema you checked in TFS.

More info on this can be found using the below link:

http://www.red-gate.com/supportcenter/Content?p=SQL%20Source%20Control&c=SQL_Source_Control/help/2.2/SSC_WE_Setting_up_TFS.htm&toc=SQL_Source_Control/help/2.2/toc.htm

HTH!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group