mdawley4
asked on
Move SSAS Databases 2008 R2 to 2012
Hello,
I am moving SQL Server Analysis Services databases from SQL Server 2008 R2 64-Bit Standard Edtion to SQL Server 2012 64-Bit Standard Edition. The databases are moving from one physical server to another physical server. Here's the problem.
I backed up an SSAS database on 2008 R2 server, password protected. I copied the backup file (ABF) to the 2012 server. On the 2012 server I open the SSAS instance, right-click the Databases folder and choose Restore... from the menu. I select the ABF 'Backup file', enter the 'Restore database' name and enter the password I used. 'Allow database overwrite' is unchecked, 'Include security information' is set to Copy All.
When I click OK, I receive a message:
"Errors related to feature availability and configuration: The 'Support of ReadOnly databases' feature is not included in the '64 Bit Standard' edition of Analysis Services. (Microsft.AnalysisServices )"
What can I do to overcome this error?
Thank You
I am moving SQL Server Analysis Services databases from SQL Server 2008 R2 64-Bit Standard Edtion to SQL Server 2012 64-Bit Standard Edition. The databases are moving from one physical server to another physical server. Here's the problem.
I backed up an SSAS database on 2008 R2 server, password protected. I copied the backup file (ABF) to the 2012 server. On the 2012 server I open the SSAS instance, right-click the Databases folder and choose Restore... from the menu. I select the ABF 'Backup file', enter the 'Restore database' name and enter the password I used. 'Allow database overwrite' is unchecked, 'Include security information' is set to Copy All.
When I click OK, I receive a message:
"Errors related to feature availability and configuration: The 'Support of ReadOnly databases' feature is not included in the '64 Bit Standard' edition of Analysis Services. (Microsft.AnalysisServices
What can I do to overcome this error?
Thank You
Have you tried using SSAS DatabaseMigration Wizard?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Philip,
Where does one find the Database Migration Wizard on SQL Server 2008 R2?
Where does one find the Database Migration Wizard on SQL Server 2008 R2?