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) ?
Best Answer
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.