VSTS 2008 Database Edition GDR – RTM has shipped

Just catching up on my reading and I noticed that Gert Drapers and the DB Pro Team have ruined another holiday weekend for a bunch of folks in VSTS land.  They shipped the “gold” release of Visual Studio Team System 2008 Database Edition GDR – RTM on 25-Nov, just in time for the long Thanksgiving holiday weekend in the US.

This release is a Major one for the DataDude team.

“Finally the moment is there, the final version of the Visual Studio Team System 2008 Database Edition GDR has been released to the web.

Although the name “GDR”, which stands for “General Redistribution Release”, implies otherwise, this really is a complete new release, based on a new architecture. We have taken the architectural changes from the Rosario project (Visual Studio Team System 2010) and rolled them forward in time. Rolling forward these changes help us align the GDR release with the upcoming Visual Studio Team System 2010 release and provide numerous new features and extensibility points in this release. If you would compare the GDR release with the “Visual Studio 2005 Team Edition for Database Professionals” or “Visual Studio Team System 2008 Database Edition” you will agree this is a completely new product! ”                                     – Gert Drapers

You need to uninstall any prior GDR releases before installing the RTM version so I advise reading the Installation section of Gert’s post.

Here are some of my favorite features from the long list on Gert’s blog.  My selections are weighted toward build and deploy because that’s where my pain points have been in the past.  Model based architecture – Everything underneath the covers is based on a true model representation of the SQL Server schema. This facilitates a true offline declarative database development system where the source code defines the shapes of the schema objects.

  • Separation of BUILD and DEPLOY. – The separation of build & deploy makes it possible to deploy the output of your database project to many different targets and different points in time. Build now produces a single artifact file hat describes the schema inside your database, called a .DBSCHEMA file. This file is used by the deployment engine to deploy your schema.
  • Standalone Deployment Engine. – The inclusion of a standalone and redistributable deployment engine makes it possible to deploy the output of your database projects (.DBSCHEMA files) to a target database without the need of having Visual Studio Team System Database Edition installed. This enables key scenarios like the inclusion of database schema deployment as part of your application installation.

I recommend that everyone check out the full list on Gert’s blog posting for all the goodness.

Here are the links.

Download page
http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en

Setup
http://download.microsoft.com/download/0/a/e/0ae1153a-8798-474a-93e6-d19299f37c8b/setup.exe

Read Me
http://download.microsoft.com/download/0/a/e/0ae1153a-8798-474a-93e6-d19299f37c8b/Readme.mht

Documentation
http://download.microsoft.com/download/0/a/e/0ae1153a-8798-474a-93e6-d19299f37c8b/Documentation.zip