Database Reference
In-Depth Information
4. The quickest way to get to the deployment wizard is to use Search in Win-
dows 7 or Windows 8. Click on the Deployment Wizard result to open up
Analysis Services Deployment Wizard .
5. On the next dialog, you will be asked to select a database to deploy. This
database can be found in the bin folder in your SSAS Cookbook Chapter
9 project folder, if you have built your project.
6. If you did not change the Model.bim file, your database will be named
Model.asdatabase . Click on OK and then on Next .
7. This opens up the dialog for the installation target. In this dialog box, you
need to specify the server and the database you plan to deploy. If your active
configuration has the correct target, you should be able to click on Next and
move the Specify Options for Partitions and Roles dialog. Leave the de-
fault settings at this point and click on Next .
8. In the Specify Configuration Properties dialog, you can change the con-
nection information as well as the impersonation information for the config-
uration. These are currently based on the settings you set up before. In our
case, you can select the first two checkboxes, which will retain your deploy-
ment settings.
Note
This allows you to change these properties prior to a production deploy-
ment. It will allow your DBAs or similar roles to set credentials upon the
deployment, which helps meet a number of compliance considerations in
various industries.
9. The next dialog, Select Processing Options , we will also leave it with its
default settings.
10. Finally, in the next dialog, you have one last chance to back out as you will
overwrite the existing database with the same name. Once you click on Next
here, you will deploy the database. After it is complete, you have one more
dialog box, which will close the dialog.
11. The Deployment utility is a command-line deployment option. This option
uses the ASDATABASE file as well. So let's open command prompt and de-
ploy the database using this option. You will find the executable here:
Search WWH ::




Custom Search