Recently, on codeplex the Application Lifecycle Management Rangers from Microsoft have made available guidance on database development practices when using Visual Studio 2010 database projects. This practical guidance is focused on the following topics:

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

How does guidance differ from MSDN documentation?

This guidance discusses scenarios and approaches of using the Database Projects in Visual Studio 2010 to help you use the tools more effectively and maximize their value to your organization.

The MSDN documentation provides a basic understanding of the product and how to use them, whereas this guidance is based on real-world experience, about the best way to use the technology. Occasionally you will also encounter features or limitations in the product or the platform which require you to implement a custom process in order to achieve the desired goal. This guidance is designed to complement the information on MSDN, helping you to use Visual Studio Database Projects more efficiently

The scenarios used in this document include common scenarios such as reverse engineering an existing solution or starting a new solution from scratch. These scenarios are challenges that any analyst, architect, or developer faces in real life. The intention is not to give you an in-depth tour of the product features, but to present you with common scenarios, practical guidance, and checklists.

The below table highlights the differences of offering on DB projects in VS 2010 Professional vs Premium/Ultimate.

image

Link to download the guide from: http://vsdatabaseguide.codeplex.com/