2

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?

Ray
  • 12,101
  • 27
  • 95
  • 137

2 Answers2

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.

Demitrius Nelon
  • 1,210
  • 1
  • 10
  • 29
0

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

Aaron Marten
  • 6,548
  • 1
  • 32
  • 41
  • yes, tried the Deploy command, and it built a bunch of files in the sql/debug folder, what do I do next to populate my db? – Ray Jul 03 '10 at 04:38
  • Did you set up the target database on the Deploy page in project properties? – Aaron Marten Jul 08 '10 at 15:37