Export (0) Print
Expand All

Deploying an Analysis Services Database into the Production Environment

Microsoft SQL Server 2005 Analysis Services (SSAS) provides three tools for deploying an Analysis Services database onto an Analysis Services server in the production environment:

  • Using an XML Script   Use SQL Server Management Studio to generate an XML script of the metadata of an existing Analysis Services database, and then run that script on another server to recreate the initial database.
  • Using the Analysis Services Deployment Wizard   Use the Analysis Services Deployment Wizard to use the XMLA output files generated by an Analysis Services project to deploy the project's metadata to a destination server.
  • Synchronizing Analysis Services Databases   Use the Synchronize Database Wizard to synchronize the metadata and data between any two Analysis Services databases.

In addition to using one of the deployment tools, you can deploy Analysis Services by using the backup and restore functionality. For more information, see Backing Up and Restoring an Analysis Services Database.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft