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

Migrate SSRS 2005 to SSRS 2008? Expand / Collapse
Author
Message
Posted Wednesday, February 17, 2010 1:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:03 PM
Points: 244, Visits: 211
hello:

re: sql server 2005/SP2 with SSRS

i would like to migrate reports from mssql2005 ssrs to a new mssql2008/SP1 ssrs environment ... any thoughts or suggestions or links? can just the ssrs dbs be migrated seperately?

many thanks. jeff


Many thanks. Jeff
Post #867451
Posted Wednesday, February 17, 2010 5:53 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:50 PM
Points: 2,825, Visits: 3,011
The migration is pretty straight forward when moving from SSRS 2005 to SSRS 2008. Just backup the ReportServer and ReportServerTempdb from 2005 and restore them to 2008, then point RS 2008 at them. RS 2008 will migrate the schema for you. You will need to create the RSExec role first and don't forget to backup and then restore the encryption key. See the link below for some considerations.

http://msdn.microsoft.com/en-us/library/ms143747.aspx


One final note that got me; make sure your data sources do not have spaces in them prior to upgrading from 2005 to 2008. RS 2008 will replace the spaces with an underscore and all reports depending on the data source will break. It's best to fix this prior to the migration.
Post #867644
Posted Thursday, February 18, 2010 1:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:03 PM
Points: 244, Visits: 211
thanks.

is there a way to migrate on a report by report basis?


Many thanks. Jeff
Post #868456
Posted Thursday, February 18, 2010 1:19 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:50 PM
Points: 2,825, Visits: 3,011
I believe you can just open the reports in BIDS 2008 to convert them and then upload them to RS 2008. I didn't go this route because of the 1000's of reports we have.
Post #868468
Posted Thursday, February 18, 2010 1:32 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: Sunday, July 27, 2014 12:14 PM
Points: 3,433, Visits: 14,423
Jeff-67583 (2/18/2010)
thanks.

is there a way to migrate on a report by report basis?


You have two options either copy from source control to the new report manager or you could use the SSRS scripter.

http://weblogs.asp.net/akjoshi/archive/2009/01/29/using-rs-scripter-to-create-deployment-script-for-reporting-services.aspx



Kind regards,
Gift Peddie
Post #868477
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse