Synchronize Element (XMLA)
Synchronizes a Microsoft SQL Server 2005 Analysis Services (SSAS) database with another existing database.
Syntaxe
<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 |
|
Child elements |
Notes
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 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 the Synchronize command has completed.
For more information about synchronizing databases, see Backing Up, Restoring, and Synchronizing Databases (XMLA).
Voir aussi
Référence
Backup Element (XMLA)
Batch Element (XMLA)
Parallel Element (XMLA)
Restore Element (XMLA)