Deployment Strategies - Microsoft SQL Server 2008 Analysis Services - page 809

Figure 40.4 shows the wizard's Specify Locations for Remote Partitions page, which
appears only if there are remote partitions for your database. The wizard lists all the
remote partitions for the source server under Source Server (in our example, Source Slave1
and Source Slave2). Under Destination Server, you can browse for the partitions on the
target slave servers.

FIGURE 40.4 You can use this page of the Synchronize Database Wizard to map slave
servers for synchronization.

You can't advance in the wizard until you have mapped all the source slave servers to the
appropriate target slave servers. Behind the scenes, the wizard is composing a DDL
command, as most wizards do. The wizard uses the information on this page to compose
the part of the command that maps the source slaves to the target slaves. Listing 40.3
contains that part of the Synchronize command.

LISTING 40.3

Mapping Remote Partitions

<Location>
<DatasourceID>Slave1</DatasourceID>]
<DataSourceType>Remote</DataSourceType>]
<ConnectionString>Provider=MSOLAP.4;Data Source=Target Slave1;Initial
Catalog=Slave1</ConnectionString>
</Location>