Visual Studio ALM Rangers made e very good guide for developing database projects integrated as a Visual Studio 2010 project type. This new project type enables you to create and maintain your project database, such as tables, views and stored procedures together with your code. The project type also is integrated with source control, build, testing and deployment capabilities in Visual Studio 2010 (Ultimate). The guide is located at codeplex.com, but if you are lazy, just wait for my posts on this feature 🙂
I’m not sure yet, but I suspect this project type is only available in the Ultimate version of Visual Studio 2010. When you are adding a new project, select the “Database | SQL Server” project templates and choose the “SQL Server 2008 Database project” type. See screenshot below.
This project type has the following main areas:
- Data Generation Plans. Enables you to create basic configuration and test data for your application
- Schema Comparisons. Compare schema changes in two different version.
- Schema Objects. All tables, views, stored procedures and so on.
- Scripts. Pre- and post execution deployment scripts.
For this project type, you have the possibility to watch how the actual schema will look like, in addition to a specialized Solution explorer windows similar to the explorer in SQL Server Management Studio (SSMS).
I will have to read the full guide (91 pages) before proceeding with my posts… cy’all