Database Reference
In-Depth Information
deploy step, and not perform a full process of the database. Now the server only
contains the metadata describing the objects, but no data has been fetched from the
relational database that is used as the source of the cube. We will look at the pro-
cessing later in this chapter, but now on to other ways of deploying your cube pro-
jects.
Deploying projects using advanced deployment
strategies
Interactive deployment is common during the development of your cube when you
work on the development server. However, when you deploy the project into produc-
tion, you typically want to do this during the night, and preferably you want to sched-
ule it. Analysis Services provides other ways for you to deploy your code. One of
them is to execute the XMLA script by itself. You can retrieve the XMLA script for
your database by right-clicking on the database in the
Object Explorer
window in
Management Studio and navigating to
Script Database as
create.
This script can then later be executed against the server in order to create the data-
base and all the objects in the database. This is something that you often do to cre-
ate automated deployment configurations, wherethe script isexecuted asscheduled
jobs.
Search WWH ::
Custom Search