Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Analysis Services Synchronization for SQL Server 2005 Standard Edition Expand / Collapse
Posted Monday, August 16, 2010 3:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 8, 2010 9:47 AM
Points: 1, Visits: 11
We have SQL Server 2005 Standard Edition for 3 servers. We have successfully implemented transactional replication between those servers for our datawarehouse databases. But it appears that synchronization for Analysis Services databases does not come with the 2005 standard edition. When using the synchronization wizard, it allows us to go through all the steps, and then choose "Synchronize now." But immediately we get this error:

"Errors related to feature availability and configuration: The 'Synchronization' feature is not included in the 'Standard Edition' SKU. Database synchronization failed."

Does anyone know of a workaround? We want to set up the Analysis Services databases to 'replicate' or 'synchronize' in a similar way to the datawarehouse replication. We don't want to have to upgrade to the Enterprise edition of 2005. Any suggestions?
Post #970071
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse