Rangers shipped Visual Studio 2010 Database Guide

Have you ever struggled with the Database Developer (was DataDude) components of Visual Studio? Well I have…and now the ALM Rangers have released a new guide to help us all get the benefits. There is Guidance as well as Hands-On-Labs and even how to do WIX integration for deployment.

The Visual Studio 2010 Database Guide is available to download from Codeplex and you should try it out and submit some feedback. Wondering what this is all about? Well…

Project Description

Practical guidance for Visual Studio 2010 Database projects, which is focused on 5 topic 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 http://msdn.microsoft.com/en-us/vstudio/ee358786.aspx and for more a list of other Rangers projects please see http://msdn.microsoft.com/en-us/vstudio/ee358787.aspx .

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

Team

Obviously this type of work would not be possible without many people contributing their free time to make it happen.

• 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)

Technorati Tags: ALM , TFS 2010 , VS 2010 , Visual Studio