The Database Edition functionality in Visual Studio 2010 is based on our GDR release. If you have been using the GDR this is what is “new:”
The following matrix describes which ALM features are available in which Visual Studio editions and how they behave. Specifically, where it says you may “Execute” a feature in Visual Studio Professional that means you may do not have the ability modify the artifact (for example a Unit Test) but you may execute it.
Visual Studio Professional
Premium and Ultimate
Static Code Analysis
TFS Build Integration
Command line deploy
The Data Dude bits are now installed when you install a TFS Build Agent. You no longer need to install Visual Studio Team System Database Edition on your TFS Build server in order to build database projects. Database projects have first class support in TFS build. You may build, deploy, run SQL static code analysis and database unit tests. Sweet!
This is such a large topic that it will require a series of blog posts. Stay tuned.