IT:AD:Data:Db:Projects:HowTo:How to build a Database from a Db Project

• (UP)

  • IT:AD:Data:Db/Projects:HowTo:A Quick Intro
  • IT:AD:Data:Db:Projects:HowTo:Create a Project from an Existing Database
  • IT:AD:Data:Db:Projects:HowTo:Deploying DbSchemas from the CommandLine
  • IT:AD:Data:Db:Projects:HowTo:How to build a Database from a Db Project
  • IT:AD:Data:Db:Projects:HowTo:Import Existing Databases
  • IT:AD:Data:Db:Projects:HowTo:Keep incremental Scripts in Db Projects
  • IT:AD:Data:Db:Projects:HowTo:Work with Custom Variables

In Solution Explorer, rick click the project, in order to bring up its Properties, and from there go to the build tab:

WARNING: Notice the name of the db it is going to use…yeah, master…now you know why it gave you that whopping big warning up front (you certainly do NOT want to create tables in the master db).

Enter the name of the db to create, or update. In our simple demo, we’ll use the name the db we imported (just to keep my server somewhat clean) but you get the point – the operation is the same either way.

First ensure we actually are going to deploy, and not just generate scripts:

and second, edit the connection string via the popup dialog:

You’re now all ready to try: right click the project and deploy it:

If the SQL that is in the project is all good, you’re good to go!