Chapter 13. Managing Deployment

After completing this chapter, you will be able to:

  • Use the Deployment Wizard to deploy a database to an Analysis Server.

  • Process a database manually.

  • Automate database processing with SQL Server Integration Services.

  • Use SQL Server Management Studio to back up and restore a database.

Building an analytical solution is usually an iterative process, requiring several cycles of design, development, and testing to be certain that requirements have been met satisfactorily. Often these iterative cycles are performed on a test server. When at last the solution is ready to release into production, you’ll need to reproduce the database objects on the production server and then process the database to load data into the dimensions ...

Get Microsoft® SQL Server™ 2005 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.