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.

Best way to load db schema for various releases?

Postby kraades » Mon Oct 29, 2012 12: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 7:34 am

Postby james.billings » Wed Oct 31, 2012 8: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: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests