Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 BI Migration Denali

Author  Topic 

schary08
Starting Member

2 Posts

Posted - 2012-12-29 : 09:08:09
hi,
please help me on this query.how to migrate SSAS/SSRS data from sql server 2008r2 to sql server 2012.

thanks,
Sreeni

Sreenivasa Chary.T

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-03 : 02:14:10
one option is to script out objects and execute them in sql 2012 to recreate the objects. but this requires some background info on creating list of objects to be migrated etc

or if you want entire db to be recreated use backup and restore the reportserver dbs ReportServer and ReportServerTempDB after setting up report server in sql 2012 instance

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -