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