Visual Studio 2010: “SQL Server Database” project type


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.

Add new project

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

Advertisements

One thought on “Visual Studio 2010: “SQL Server Database” project type

  1. Pingback: VS2010: Database project – import script | Sveroa's Developer Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s