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.


The main enhancement to highlight is that SSAS 2005 includes an engine for use in deploying Analysis Services projects and solutions. During the development process, you can use the deployment engine to deploy new projects to a test instance of Analysis Services; when your development is complete, you can then use the engine to deploy the projects to a production instance of Analysis Services. You can use the deployment engine to synchronize metadata between a new or updated Analysis Services project in Business Intelligence Development Studio and an existing instance of Analysis Services or to overwrite metadata from one instance to another. You can also use the deployment engine at the command prompt to provide additional flexibility when you deploy Analysis Services projects and solutions