Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 126

Deployment options
You have already learned that you can deploy an SSDT project to an SSAS instance.
For enterprise-level applications, it is imperative to maintain source control—SSDT
projects can be checked in and out of version control software. Since the entire Ana-
lysis Services database can be scripted using SSMS in XMLA language, you can
also save copies of database definition in that format. Scripting is also helpful when
moving databases from test to quality assurance and subsequently to production en-
vironments. However, scripting a complex database with hundreds of partitions can
take prohibitively long. In some cases, even deployment through SSDT can hang and
might never complete. Fortunately, there is an additional option for deploying SSAS
database projects: the Deployment Wizard.
How to do it...
Let's learn how to use the Deployment Wizard by performing the following steps:
1. To activate the wizard navigate to Start | All Programs | Microsoft SQL Serv-
er 2012 | Analysis Services | Deployment Wizard .
2. After the welcome screen, the wizard lets you specify the location of the file
with an .asdatabase extension—this file is created in the bin subfolder when
you build a project with SSDT.
3. After you specify the target server and database name, the wizard displays
options shown in the following screenshot: