How to deploy a dbproj in vs2010?

Question

Quick question, I'm new to dbproj, how do you actually deploy it to my sqlserver from vs2010? I built the dbproj, and it created a bunch of files in sql/debug folder, then what do I do?

Answer 1

If you configure the database project property on the Deploy tab and set the Deploy action: to Create a deployment script (.sql) and deploy to the database with valid Target Database Settings, the database will be deployed when you use the Deploy Solution action under the Build menu.

Answer 2

There should be a "Deploy" command on the project. More details on configuring it are on MSDN: http://msdn.microsoft.com/en-us/library/aa833165.aspx