Setting Build and Deploy Properties




By:

Overview

Before we can actually build and deploy, we must ensure the build and deploy properties of our project are set.

Explanation

Alas, before we deploy we need to prep the project for Build and Deploy actions. First we need to edit the project properties by choosing DemoDB Properties... from the Project menu strip item:

edit the project properties by choosing DemoDB Properties

This produces the Project Settings screen which includes options to set Build and Deploy properties.

This produces the Project Settings screen

Choosing the Build option, we see the following:

Choosing the Build option

We see options to specify a build output path which is where the build files will go in relation to where you installed your project. This location can be overridden to any file location. The build output name references the .dbschema file name that will house the results of the build action. This is an XML file that is generated during build that contains all the objects that make up our project. We'll leave these options alone.

Clicking on Deploy, we see deployment related options. Let's focus on the Deploy action and Target Connection. For the deployment to actually create the database, we need to make sure this option creates a script and deploys it to the database. Otherwise, a script will be generated but won't be deployed. In addition, we need to set the target database connection. Choosing Edit, you can specify the SQL Server instance you wish to deploy to.

Clicking on Deploy, we see deployment related options

We are finally ready to deploy the database.


Last Update: 9/10/2011





More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download


get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools