Database Change Management with Team System 2008

• Visual Studio Team System 2008 Database Edition GDR R2 is the latest version (We need to load this version).

Builds on top of Visual Studio 2008 SP1

Adds support for SQL Server 2008

All the database features as part of the Developer version.  No additional cost.

New Architecture:

• Database Schema provider model
• Separation of Build and Deploy – knows the difference between new and incremental changes.

Build generates a DBSCHEMA file

Takes.DBSCHEMA file as input

Plus configuration files

• Public Extensibility

Power Tools

• T-SQL static
• All tools work on a single model
• No more Design DB or need for local DB instance

• Declarative DB Development

Saving all items as create scripts

Specify the shape of the schema about.  ALTER is removed

Shape definitions are used to create model representation of the schema

Schema representation:

Can round trip source > mode > source> model

programmatic interaction for designers

Make model changes

Generate artifact, like incremental deployment scripts.

• Incrementally Deploying your Databases
• Versioning your DB Schema

 

This was a tough session to document in detail because of the many demos.  The basic gist is that they have correct all the issues of the previous Versions of the DataDude.  Including that there is no more charge for the application for our developers.  Everything is stored in scripts so that the system can figure out if you have changes or if it is an initial creation.