Synchronizes a Microsoft SQL Server Analysis Services database with another existing database.

Synchronize Element (XMLA)

Other Versions

Syntax

Xml

<Command>
   <Synchronize>
      <Source>...</Source>
      <SynchronizeSecurity>...</SynchronizeSecurity>
      <ApplyCompression>...</ApplyCompression>
      <Locations>...</Locations>
   </Synchronize>
</Command>

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	Command
Child elements	ApplyCompression, Locations, Source, SynchronizeSecurity

Remarks

The Synchronize command synchronizes the target database with a source instance and database specified in the Source element. Optionally, the Synchronizecommand synchronizes remote partitions defined on the source database.

Depending on the storage mode used by objects stored in the backup file, the Synchronize command synchronizes information as listed in the following table.

Storage mode	Information
Multidimensional OLAP (MOLAP)	Source data, aggregations, and metadata
Hybrid OLAP (HOLAP)	Aggregations and metadata
Relational OLAP (ROLAP)	Metadata

During a Synchronize command, a read lock is placed on the source database and a write lock is placed on the target database. Both locks are released after theSynchronize command has completed.

For more information about synchronizing databases, see Backing Up, Restoring, and Synchronizing Databases (XMLA).