This sounds like a sweet looking package that is now in CTP 6 that I may just have to download -
“Tools for building SQL databases in a managed project environment with support for versioning, deployment, unit testing, refactoring, and off-line SQL development. This release is focused on completing a full functionality scenario for SQL 2000 and includes an updated project system with reverse engineering, a new SQL Query Editor, Schema and Data Compare, Data Generation, Unit Testing, and Rename Refactoring.”
You can see a preview of it tomorrow at the quarterly Tampa MSDN Event -
Session 1: Take Control of the Database Development Lifecycle with Visual Studio Team Edition for Database Professionals
“Have you ever had to test code under development against the "production" version of your database, simply because it was the only copy that was the "truth?" If so, you know first-hand the challenges of managing a database as it moves throughout the software development life cycle. Visual Studio Team Edition for Database Professionals (VSTE-DB Pro), scheduled for release in late 2006, extends the Visual Studio Team System with progressive tools that make it easier to create and test applications that work with databases.
In this session, you'll learn best practices for keeping your development, test and production databases in sync from a schema and data perspective. We'll explore how to create and version database schemas, and how to utilize schemas for 'off-line' development against a database schema. You'll see how to create test data that truly mimics real data, and how to use Unit Tests to validate your application against a database. Finally, we'll explore how to manage database schema changes using Team Foundation Server – making database development a true participant in the software development life cycle.”
Source: David Hayden ( Florida .NET Developer )