DBPROJ vs. DBP

Can the “real” database project please identify itself?

Life can be confusing and we did not help you making it much easier by having two types of Database Projects inside Visual Studio. For the longest time there has been a “Database Project” inside Visual Studio. This project type has the file extension of .DBP and is available under the Other Project Types\Database\Database Project node inside the New Project dialog. It has not evolved for many releases and is purely there for legacy support.

This project type (.DBP) does not provided you with any of the Database Edition functionality. However if you have a Visual Studio edition that does not support the Database Edition functionality, like Visual Studio 2008 Professional, this is all you have. Sorry!

The simplest check is to look at the file extension of your project file, if it is a .DBP project, this is the old Database project file.

A second way to identify an old database project is based on the layout projected inside Solution Explorer:

If you are looking of the latest Database Project functionality, you want to make sure you have the GDR release installed. This adds a new root node inside the New Project dialog, named “Database Projects”, underneath you will find nodes/folders per provider. By default you will have a SQL Server 2000, SQL Server 2005 and SQL Server 2008 folder. All these projects share the common file extension of .DBPROJ.

Hopefully this makes it a little bit more clear which one is which, and which one it is you should be using.

-GertD @ www.DBProj.com

Comments

• Anonymous
  March 25, 2009
  PingBack from http://blog.a-foton.ru/index.php/2009/03/25/dbproj-vs-dbp/

• Anonymous
  March 30, 2009
  Ognjen Bajic on [Inside TeamCompanion 2.1] Query by Example (QBE) The Data Dude Blog on Can the "real"

• Anonymous
  July 08, 2009
  Very clear. We are using DBPROJ for the real database projects and using DBP for SQL on Server level  like creating jobs, job catergories, job schedules, operators and alerts. There is another database project you missed. Under Visual C# you'll find Database and the SQL Server Project. This one ends as csproj. Never used this one however. Constantijn

• Anonymous
  July 21, 2009
  Introducing such a topic you'd like to congratulate you've let us know. Have good work...

• Anonymous
  June 21, 2010
  It can't get any clearer than this! Thanks for shedding some light on this old topic...