Is there a way to synchronize SQL 2008 SSAS database to 2012 server?

Question

Greetings,

We are assessing migration to 2012 from 2008 (not R2). While attempting to use Database Synchronization wizard, the following error appears and the process fails:

Database synchronization started.
Errors in the OLE DB provider. The server returned the following error:  (The OlapInfo element at line 1, column 1686 (namespace ) cannot appear under Envelope/Body/Execute/Command/InternalSynch/BackupLog.).  
Backup and restore errors: An error occurred while synchronizing the 'Cube' database.  
Database synchronization failed.

There is the option of opening 2008 database in VS 2012 and then deploying/processing it manually but have have huge SSAS databases that would take days to reprocess if we go that way.

Please advise. Thanks

 

Answer 1

Polaro,

You should be able to use attach/detatch to move the SSAS databases from the old to new version of SSAS.  Essentially, detatch from the old instance in SSMS, copy the files to the DATA folder of the new SSAS instance, then attach to the new instance in SSMS.

http://msdn.microsoft.com/en-us/library/cc280583.aspx

HTH,

Rob

---

Rob Kerr SQL Server MVP CTO, BlueGranite

Answer 2

Thanks Rob, tried detach/attach and it works.  Synch would be ideal though, easier to automate