Chapter 15. Managing Deployment

In this chapter, you will learn how to:

  • Deploy an Analysis Services database using BIDS.

  • Create an XMLA script to deploy an Analysis Services database.

  • Execute deployment scripts against an Analysis Services server.

  • Migrate Analysis Services databases from one server to another.

  • Perform backups and restores of Analysis Services databases.

This chapter examines two areas of managing an Analysis Services implementation: how code changes to an Analysis Services database are deployed to a server, and how to migrate existing databases across servers as well as how to handle disaster recovery.

Deployment Overview

When we talk about deployment, we are really focusing on the process of moving code changes in an organized manner ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.