Delen via


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

Technorati Tags: DBP,database,project,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: msdn.microsoft.com/en-us/library/ee517378(VS.100).aspx

Comments

  • Anonymous
    September 20, 2010
    Where is the RUN and RUN ON commands?

  • Anonymous
    March 10, 2011
    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