September 1, 2015 at 6:15 am
We have a SQL Server 2012 installation that was built on...let's say a compromised Windows installation. It's had so many installs/uninstalls done on it that nothing runs consistently, and we're moving off it to a new clustered instance. However, I can't seem to get the Analysis Services databases moved. All the articles I find are about migrating from 2005 or 2008 to 2012, and reference MigrationWizard, which apparently does not exist with SQL Server 2012.
Has anyone moved Analysis Services from one platform to another, both under 2012?
September 1, 2015 at 8:54 am
Yes.
Install SSAS on the new server (use the same version and fix level as the old SSAS), set the AS security to match the old server, set the AS options to match the old AS server options (except for the directories as they may be different depending upon how you installed and IF the disk drives/paths are the same), back up the SSAS DB's and restore them on the new server.
note: If you have issues accessing the AS security/options on the new server R-Click SSMS and Run as Administrator then connect to AS.
We then re-IP/re-name the old server then re-IP/re-name the new server to match the old server so that the end users have no changes to make.
Hope this helps!
edited: Sorry all you need to do is backup the AS DB's and restore them on the new AS clustered instance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply