Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

URGENT: Migrate/Move SSRS 2008r2 Reports to SSRS 2012 Expand / Collapse
Author
Message
Posted Monday, August 18, 2014 2:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:42 PM
Points: 20, Visits: 130
Hello Folks,

I have a 2008R2 Report Server and I have almost 40 reports, 10 DataSources and aorund 60 Datasets.
I got a new Server with 2012 and SQL Server 2012. I need to move/migrate all the reports to new server (2012).

I moved the ReportServer DB from OLD to NEW Server. Now i need to move the reports. If it is one or two Reports, i can download the RDL file and upload to the new server and add DataSource and DataSet. No issue. But i cant do this for 40 reports manually.

Is there any way i can migrate all the reports, DataSources and Datasets from OLD server to New Server.


Thanks,
SK
Post #1604675
Posted Thursday, August 21, 2014 8:54 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, August 23, 2014 9:39 AM
Points: 174, Visits: 573
Use the reporting scripter tool. I have used it, works well.

-------------------------------------------
I'm not afraid of storms, for I'm learning to sail my ship
Post #1605875
Posted Thursday, August 21, 2014 10:09 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 3,026, Visits: 2,630
sqlstunner (8/18/2014)
Hello Folks,

I have a 2008R2 Report Server and I have almost 40 reports, 10 DataSources and aorund 60 Datasets.
I got a new Server with 2012 and SQL Server 2012. I need to move/migrate all the reports to new server (2012).

I moved the ReportServer DB from OLD to NEW Server. Now i need to move the reports. If it is one or two Reports, i can download the RDL file and upload to the new server and add DataSource and DataSet. No issue. But i cant do this for 40 reports manually.

Is there any way i can migrate all the reports, DataSources and Datasets from OLD server to New Server.


Thanks,
SK


One option (assuming that the SQL 2012 instance doesn't have any report yet), is to backup the SQL2008R2 ReportServer/ReportServerTEMPDB databases and the encryption key and restore them to the SQL2012 instance over the top of the SQL2012 equivalent database/encryption key. When the SQL2012 instance starts up, it checks the version of the database and upgrade things in it. You should end up with all reports, datasources, security etc exactly as it was in the SQL2008R2 instance with all encrypted content (database logins and the like) ready to go. No need to migrate each report, datasource etc.



Post #1606098
Posted Tuesday, August 26, 2014 9:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 1:33 PM
Points: 67, Visits: 237
Don't think we need to restore ReportserverTempDB
Post #1607493
Posted Tuesday, August 26, 2014 12:36 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:43 AM
Points: 256, Visits: 1,515
I have used this in the past and it worked really well (easy too).


http://code.google.com/p/reportsync/
Post #1607577
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse