jueves, 10 de mayo de 2012 15:58
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
Todas las respuestas
viernes, 11 de mayo de 2012 3:09
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.
Rob Kerr SQL Server MVP CTO, BlueGranite
- Marcado como respuesta polaro viernes, 11 de mayo de 2012 15:58
viernes, 11 de mayo de 2012 16:00Thanks Rob, tried detach/attach and it works. Synch would be ideal though, easier to automate