TechNet
Export (0) Print
Expand All

Synchronize Element (XMLA)

 

Applies To: SQL Server 2016 Preview

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

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

CharacteristicDescription
Data type and lengthNone
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
RelationshipElement
Parent elementsCommand
Child elementsApplyCompression, Locations, Source, SynchronizeSecurity

The Synchronize command synchronizes the target database with a source instance and database specified in the Source element. Optionally, the Synchronize command 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 modeInformation
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 the Synchronize command has completed.

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

Backup Element (XMLA)
Batch Element (XMLA)
Parallel Element (XMLA)
Restore Element (XMLA)
Commands (XMLA)

Community Additions

ADD
Show:
© 2016 Microsoft