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 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.