This project has moved and is read-only. For the latest updates, please go here.

Refer to library of tooling and guidance solutions ( for details.

Project Description

Practical guidance for Visual Studio 2010 Database projects, which is focused on 5 areas:

  • Solution and Project Management
  • Source Code Control and Configuration Management
  • Integrating External Changes with the Project System
  • Build and Deployment Automation with Visual Studio Database Projects
  • Database Testing and Deployment Verification

This release includes common guidance, usage scenarios, hands on labs, and lessons learned from real world engagements and the community discussions.

The goal is to deliver examples that can support you in real world scenarios, instead of an in-depth tour of the product features.

Visual Studio ALM Rangers

This guidance is created by the Visual Studio ALM Rangers, who have the mission to provide out of band solutions for missing features or guidance. This content was created with support from Microsoft Product Group, Microsoft Consulting Services, Microsoft Most Valued Professionals (MVPs) and technical specialists from technology communities around the globe, giving you a real-world view from the field, where the technology has been tested and used.

For more information on the Rangers please visit and for more a list of other Rangers projects please see

What is in the package?

The content is packaged in 3 separate zip files to give you the choice of selective downloads, but the default download is the first of the listed packages:

  • Visual Studio Guidance for Database Projects --> Start here
  • Visual Studio Database Projects Hands-On-Labs document
  • Hands-On-Labs (HOLs), including:
    • Solution and Project Management
      • Refactoring a Visual Studio Database Solution to Leverage Shared Code
    • Source Code Control and Configuration Management
      • Single Team Branching Model
      • Multiple Team Branching Model
    • Integrating External Changes with the Project System
      • Maintaining Linked Servers in a Visual Studio Database Project
      • Complex data movement
    • Build and Deployment Automation
      • WiX-Integration with deployment of databases
      • The Integrate with Team Build Scenario
      • Building and deploying outside team build
    • Database Testing and Deployment Verification
      • The “Basic” Create Unit Test Scenario
      • The “Advanced” Create Unit Test Scenario
      • Find Model drifts Scenario


  • Contributors
    • Shishir Abhyanker (MSFT), Chris Burrows (MSFT), David V Corbin (MVP), Ryan Frazier (MSFT), Larry Guger (MVP), Barclay Hill (MSFT), Bob Leithiser (MSFT), Pablo Rincon (MSFT), Scott Sharpe (MSFT), Jens K. Süßmeyer (MSFT), LeRoy Tuttle (MSFT)
  • Reviewers
    • Christian Bitter (MSFT), Regis Gimenis (MSFT), Rob Jarrat (MSFT), Bijan Javidi (MSFT), Mathias Olausson (MVP), Willy-Peter Schaub (MSFT)

How to submit new ideas?

The recommended method is to simply post ideas to the Discussions page or to contact the Rangers at


Post comments on the Discussions page.

Last edited Jan 9, 2017 at 5:40 PM by wschaub, version 15