Red Gate forums :: View topic - Best way to load db schema for various releases?
Return to www.red-gate.com RSS Feed Available

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

Best way to load db schema for various releases?

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kraades



Joined: 23 Oct 2012
Posts: 5

PostPosted: Mon Oct 29, 2012 1:52 pm    Post subject: Best way to load db schema for various releases? Reply with quote

We have different releases of the product each with a different database schema.
We would like to load the db schema for all branches into SSC.

DEV (latest db schema V2.1)
-->
MAIN
-->
RELEASE
- V1.0 (db schema V1.0)
- V1.1 (db schema V1.1)
- V2.0 (db schema V2.0)
Etc.

What is the best way/order to load the database schema for REL V1.0, REL V1.1, REL V2.0, MAIN and DEV?
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1120
Location: My desk.

PostPosted: Wed Oct 31, 2012 9:43 pm    Post subject: Reply with quote

I guess there's various ways you could do this.

One way would be: when you reach a cutoff point (say, v1.9 is done with, and you're about to start work on 1.10) you could link your DB to a new 1.9 folder in SVN/TFS etc, commit the entire thing, then unlink. This way, you have a separate copy.

It's more normal to just keep working in the same repo though, having made sure the final commit for 1.9 was appropriately labelled. You can then, at any point, update a DB to that version using SQL Compare. Note that this method relies on being able to browse the history revisions though so it won't currently work with GIT/Mercurial etc, you'd need to be on SVN/TFS.
Back to top
View user's profile Send private message
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