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.

image

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:

image

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.

image

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 (5)

  1. Ognjen Bajic on [Inside TeamCompanion 2.1] Query by Example (QBE) The Data Dude Blog on Can the "real"

  2. 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

  3. bayrak says:

    Introducing such a topic you’d like to congratulate you’ve let us know. Have good work…

  4. TDN says:

    It can't get any clearer than this! Thanks for shedding some light on this old topic…

Skip to main content