Red Gate forums :: View topic - How do I create a version in SQL Server Source Control?
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

How do I create a version in SQL Server Source Control?

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



Joined: 14 Feb 2008
Posts: 9
Location: School of Clinical Medicine, University of Cambridge

PostPosted: Fri Apr 22, 2011 10:49 am    Post subject: How do I create a version in SQL Server Source Control? Reply with quote

I am using SubVersion as the back-end of SQL Server Source Control and want to create benchmark versions. How can I do this?
_________________
Mark Thornton
Database Developer
School of Clinical Medicine
University of Cambridge
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: Mon Apr 25, 2011 11:37 am    Post subject: Reply with quote

Hi Mark,

Thanks for your post. There isn't any way within SQL Source Control to give a DB a version number unless you add a version number with the initial commit that then ties up with the revision number in SVN.

I suspect that what you would want to do is create branches in SVN and then have all iterations of a DB lined against those branches. When you decide to change the version of the DB that you have linked, you simply unlink and then relink with the new branch.

For example, you could have a single Dev DB and the following in SVN:

/trunk
/branches/0.9
/branches/1.0
/branches/1.1

Initially, the Dev DB would be linked to Trunk and then you could sync to SVN. This would then put the "source" of the DB inside SVN. You would then probably unlink and then relink the DB to /branches/0.9 s you could make X number of changes within a given version. Once you were happy with that, you would probably port the code over to a separate branch, i.e. /releases/0.9 and then link the DB up to /branches/1.0.

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