×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Development and Production VSS database

Development and Production VSS database

Development and Production VSS database

(OP)
I need to set up the environment where there is two identical VSS databases (same projects) but one only holds production code and the second one is the development code that gets checked in nightly. Once code is promoted into production it needs to be promoted from development VSS to production. Production should hold only production code so if you roll back in production you would roll back to previous version of production code. I was wondering if anybody have done the similar thing and what is the best way for updating the production VSS projects with the projects from development VSS
Thanx

RE: Development and Production VSS database

I have done this very thing for the company I work for. I took some ideas from an excellent article I read on the subject, and modified the architecture to work for our environment. See: http://msdn.microsoft.com/msdnmag/issues/0500/source/de...

This article describes using a web server and ASP pages to manipulate VSS.  I created a full-fledged VB tool that our company uses to manage all of the check in/out, demotion, promotion, seeding, etc. involved with our development enviroment.

We use two physical VSS databases.  On the development database, we set up promotion levels for managing a "Development/QA/Pre-Production" environment so that code is isolated in each development stage during the development process.

Code is "demoted" from production to development by checking it out to a username that is the version that we are working on.  (in the example below, the username would be "MYPRODUCT V5.3") The version 0_Development VSS project is then seeded with the projects/files that have been checked out of production.

As development proceeds, code is "promoted" from 0_Development to to 1_QA for testing.  If testing is successful, code is then promoted to 2_Pre-Production.  If QA determines that more work is needed, code is "demoted" back to 0_Development for more work. (I used the article's convention of prefacing the promotion level VSS project names with 0,1,2 so the display in VSS is consistent with the level.)  

When we are ready to promote back to production, we do a GET from 2_Pre-Production.  We then go to the production database and check in all projects that have been promoted.

In this way we maintain a complete product version history in our production database that stays nice and clean because it doesn't have tons of individual developer history.

--------------
Production VSS
--------------
MYPRODUCT
     COMPONENT1       CHECKED OUT TO MYPRODUCT V5.3
     COMPONENT2       CHECKED OUT TO MYPRODUCT V5.3
     COMPONENT3       CHECKED OUT TO MYPRODUCT V5.3
     etc.


---------------
Development VSS
---------------
MYPRODUCT V5.3
     
     0_Development
           COMPONENT2
     
     1_QA
           COMPONENT1
     
     2_Pre-Production
           COMPONENT3

Let me know if you would be interested in the source for the tool...
           

RE: Development and Production VSS database

Amicidavinci.
I would be interested in the source for your VB app...

RE: Development and Production VSS database

(OP)
Amicidavinci thank you for your respond. What you are describing is very close to what I need. I would be interested in the souce for your application

RE: Development and Production VSS database

sg041,amicidavinci, could you please help me - I need to set up the same thing (prod and dev db's) - I have no idea how to start...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close