What happened to DBP (aka database) projects in Visual Studio 2010?


In Visual Studio 2010 DBP projects (also known as database projects) have been replaced by DBPROJ projects (aka SQL Server 2005 or 2008 Database Projects). DBPROJ projects have only been available in Visual Studio Team System 2005 and 2008. Now these project types are available in Visual Studio 2010 Professional, Premium and Ultimate editions.

image

 

How do I migrate my DBP projects to Visual Studio 2010?

Refer to this blog post for a tool that will automatically convert your project into a DBPROJ project: Converting .dbp files to .dbproj files

Refer to this MSDN documentation for detailed instructions on doing the conversion by hand: http://msdn.microsoft.com/en-us/library/ee517378(VS.100).aspx


Comments (2)
  1. Marco says:

    Where is the RUN and RUN ON commands?

  2. Tushar says:

    I myself have been annoyed by the missing functionality in Visual Studio 2010. I have looked at various options/alternative to manage and deploy the scripts on the server, but nothing was as easy as it was in Visual Studio 2008.

    Finally, I have created a tool which would allow you to deploy and run the SQL scripts as you used to do in Visual Studio 2008. This project would be made available by March 15, 2010. Its free and can be downloaded at sqlexecuter.codeplex.com

    Will be looking forward for your suggestions and feedback.

    Cheers!!!

    Tushar

Comments are closed.

Skip to main content