Visual studio team System 2008 Database Edition

This was a demo of the new DBPro for Visual Studio 2008.

Presenter: "Data Dude" Gert Drapers

Will release in June 2008
RTM in 6-8 weeks after SQL Server 2008 RTM

• Will be model based and will no longer require a local instance of the DB
• Separation of the build and deploy
• Schema will be saved in .SQL files and will break them down into small components.
• Refactoring will happen automatically when a change is made to the db. It will list all the areas that are affected prior to the actual refactoring process.
• User projects and Server Project have been separated
• Can create composite project to limit rights to the tables so developers can create views,procedures and functions, but can't touch the tables.
• Database References have been improved.
• Improved Schema Compare but the RedGate product is still better and will cost $395.00
• Full support for SQL Server 2008.

Summary: They have made some major improvements to the DBPro, especially in the area of DB references and full support for SQL Server 2008. Still can't be used by the Developer Edition of the Visual Studio which means that Steve, Alan and I will be the only ones to use this product.