Share via

  • Article

Synchronize Database Wizard F1 Help (Analysis Services)

Use the Synchronize Database Wizard to synchronize a Microsoft SQL Server Analysis Services database on one instance with an Analysis Services database on another instance. You can synchronize both local and remote partitions during the synchronization process, and specify the level of security to be synchronized by the wizard.

The Synchronize Database Wizard guides you through the following steps:

  • Selecting the Analysis Services source instance and database from which to synchronize.

  • Select storage locations for local partitions on the destination instance.

  • Select storage locations for remote partitions on other destination instances.

  • Select the level of security and membership information to copy from the source instance and database to the destination instance.

  • Select whether to synchronize immediately or to save the XML for Analysis (XMLA) Synchronize command generated by the Synchronize Database Wizard to a script file for later synchronization.