Sync SSAS Cube From One Environment to Another


Please Execute the Below Mentioned Script in Either the SQL Agent Job or XMLA Script Window or in the SSIS Package using the "Analysis Services Execute DDL Task" - 

<Synchronize xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance"xmlns:xsd="https://www.w3.org/2001/XMLSchema"xmlns="https://schemas.microsoft.com/analysisservices/2003/engine">
<
Source>
<
ConnectionString>Provider=MSOLAP.6;Data Source=SOURCESERVER; Integrated Security=SSPI;Initial Catalog=SourceCubeName</ConnectionString>
<
Object>
<
DatabaseID>SourceCubeName </DatabaseID>
</
Object>
</
Source>
<
SynchronizeSecurity>CopyAll</SynchronizeSecurity>
<
ApplyCompression>true</ApplyCompression>
</
Synchronize>

Comments

Popular posts from this blog

SSIS vs. T-SQL

Pump data from one server to another Efficiently