VS Team Edition for Database Professionals

Microsoft have finally got on the bandwagon, instead of having to use tools from Reg Gate software such as SQLCompare when Team system releases in late 2006 you will be able to add new database objects through your project, compare database schemas (even if they aren't part of your Database Project), compare the data contained within a table for differences, reverse-engineer objects from a database to a project, generate test data for your database, and write unit tests against database objects. It also allows you to put a database schema under source control so any changes made can be scripted out to run against other production databases.

These are all excellent and well needed features that were previously only available in other standalone products.

Get the CTP here...

Visual Studio 2005 Team Edition for Database Professionals