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

Using the Synchronize Database Wizard

To open the Synchronize Database Wizard from SQL Server Management Studio, right-
click the Databases node in the tree console and select Synchronize from the contextual
menu. Figure 40.2 shows the Synchronize Database Wizard.

FIGURE 40.2 You can use the Synchronize Database Wizard to synchronize two databases.

1. On this first page, in the Source Server text box, type or select the name of the server
that contains the database you want to copy from.
In the Source Database text box, type or select the name of the database you want
to copy from.
The Destination Server text box is automatically populated for you.
2. Next, you specify your security options. Select Skip Membership if you want to skip
the membership information for Analysis Server security roles. Select Copy All if you
want all the membership information in the source server to be copied to the target
server. If you select Ignore All, the target server keeps all roles and their members as
they were before the synchronization operation.
3. For the last step, either you can synchronize your databases now or you can save the
script that the wizard automatically created as you made your choices.

Using a DDL Command to Synchronize Databases

If you prefer, you can work directly with the DDL command instead of using the
Synchronize Database Wizard user interface to synchronize your database. The easiest way
to explain this is to start with the wizard.