databasedeploymentvisual-studio-2010dbproj

How to deploy a dbproj in vs2010?


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?


Solution

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