Skip to content

synchronize-element-xmla.md

Latest commit

 

History

History
86 lines (71 loc) · 3.88 KB

synchronize-element-xmla.md

File metadata and controls

86 lines (71 loc) · 3.88 KB
title Synchronize Element (XMLA) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
Synchronize Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
microsoft.xml.analysis.synchronize
urn:schemas-microsoft-com:xml-analysis#Synchronize
helpviewer_keywords
Synchronize command
ms.assetid 9401323c-feff-409a-a9da-94aee47e0563
caps.latest.revision 15
author jeannt
ms.author jeannt
manager erikre

Synchronize Element (XMLA)

Synchronizes a [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] database with another existing database.

Syntax

  
<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 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).

See Also

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