2010 Beta 2 Database Projects available in downloadable VMs

Been putting off evaluating Visual Studio 2010? New VMs are available to download that includes Visual Studio 2010 Beta 2 Ultimate and Team Foundation Server 2010.  It’s now easier than ever to evaluate Beta 2. They come in 3 flavors:   ·         Visual Studio 2010 Beta 2 (Hyper-V) ·         Visual Studio 2010 Beta 2 (Windows…


Visual Studio Premium and Database Projects

Visual Studio 2010 Beta 2 is available!  For those of you who are MSDN subscribers you can download it today through MSDN subscriber’s page. For everyone else you will have access to it on Wednesday.   Visual Studio Database Edition features are now in Visual Studio 2010 Premium.  The Database Project is also available in…


Using local 3-part names in programmability objects

VSTS:DB does not support self-referencing 3 part names. It does support external 3 and 4 part references.  For folks wondering what the difference is it is basically the use of fully qualified 3 part names identifiers for all objects in your programmability objects including local objects.  For instance you would refer to a table that is in the…


Installing GDR R2 with different languages side-by-side

The GDR R2 has a limitation that it uses the same product id for all localized versions of the product.  This prevents you from installing more than one localized version of the product.  If you have a need to install multiple language versions of GDR R2, you can do so by employing the following work…


Overview of composite and partial database projects

A colleague published a new white paper on composite and partial  database projects.  If you want to understand the difference or see how these project types are used check this out:   Collaborative Development with Team System 2008 Database Edition http://msdn.microsoft.com/en-us/library/dd452417.aspx


Deploying Composite Projects through a Database Unit Test Run

A customer asked me the other day how they could deploy Composite Projects as a part of a Database Unit Test run. They are using the Composite Project to segment their Database Projects into 2 projects for maintainability and deployment reasons.  1 schema is for a database they ship to customers as part of a…


Come visit/revisit The Beer House! (Continuous Integration)

Isn’t it funny how a simple word like Beer can grab your attention?  In this post we will look at migrating The Beer House (TBH) sample application database to be managed by VSTS:DB.  For those in the NW you may have seen this previously as I have presented this to the PNWSQL User Group. Since…


Managing data motion during your deployments (Part 2)

This post finishes off a 2 part post. Sorry about the delay getting this second part out. I went on a vacation back in May and I am just now getting caught up. In Part 1 we reviewed how to use the pre and post deployment scripts to manage data motion required to deploy some…


Maintaining and synchronizing your reference data through the database project

For database application developers working on data driven applications their reference data is as important and meaningful as the database schema itself.  In fact, the database schema is incomplete when the reference data is absent.  When I say reference data, I am speaking of the non transactional data within the database.  This data goes by…


Managing data motion during your deployments (Part 1)

Continuing with the VSTS: DB Best Practices post series, let’s take a look at managing data motion in your deployments. This will be Part 1 of a 2 part post.  In the first post we will take a look at managing data motion necessary to make table schema modifications while hanging on to your existing…