Synchronizing databases
Analysis Services database synchronization is a very useful feature that allows the database administrator to copy database files from the source to target SSAS instance. Synchronization is always incremental; it only copies the files that are different on the source instance as compared to the same files on the target instance. This enables the administrator to ensure that the source and target instance have the same data with minimal effort. Because synchronization is incremental, it could be much faster than collecting the backup and restoring the full database to the target instance.
Synchronization always works in the pull mode—the command is executed on the target instance. Synchronization is also single threaded, ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
