Best way to load db schema for various releases?

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

Best way to load db schema for various releases?

Postby kraades » Mon Oct 29, 2012 1:52 pm

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)
- V1.0 (db schema V1.0)
- V1.1 (db schema V1.1)
- V2.0 (db schema V2.0)

What is the best way/order to load the database schema for REL V1.0, REL V1.1, REL V2.0, MAIN and DEV?
Posts: 5
Joined: Tue Oct 23, 2012 8:34 am

Postby james.billings » Wed Oct 31, 2012 9:43 pm

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.
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