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.
| 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,SreeniSreenivasa 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 etcor 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
BI Migration Denali