We are upgrading our SQL Server 2008R2 to 2012 and separate the SQL Server engine from SSAS and SSRS. We want put on Server 1 the engine and on Server 2 SSAS and SSRS.

I did the side-by-side migration for the database. Now the SQL Server Engine and databases are on the SQL Server 2012(server 1). On the older server we have SSAS and SSRS we want to migrate to new SQL Server 2012 server by itself.

My Question is:

How to move the SSAS and SSRS from SQL Server 2008R2 to the new SQL Server 2012(Server 2) ?

  • 1
    Is there anything in SSAS that only exists in SSAS? Just re-deploy your solutions and process the cubes on the new instance? Are you in native or sharepoint mode for SSRS?
    – Dave
    Aug 5 '15 at 21:14
  • @Dave The cubes need to be in SSAS and SSRS is in native. I have never moved SSAS and SSRS to different server. can you direct me to some articles or document helps me to understand how to deploy . Aug 6 '15 at 13:42

Unless you have data in your SSAS cubes that no longer exists in your source (if this is the case correct that going forward!) then you can simply install a new instance of SSAS then deploy and process your SSAS solutions from SSDT (the 2012+ replacement for BIDS).

For SSRS if you have a basic install you can do the same thing - simply install the new server and deploy your reports. If you have a lot of reports, folders, security setup, schedules etc. then you should migrate.

Here are the MSDN Documents outlining the steps to migrate and the considerations prior to doing so.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.