Migrate SSRS 2005 to SSRS 2008?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Administration » Migrate SSRS 2005 to SSRS 2008?

Migrate SSRS 2005 to SSRS 2008?

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff-67583

Posted Wednesday, February 17, 2010 1:12 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, December 21, 2012 8:53 AM
Points: 244, Visits: 187

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

JeremyE

Posted Wednesday, February 17, 2010 5:53 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:17 PM
Points: 2,392, Visits: 2,660

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

Jeff-67583

Posted Thursday, February 18, 2010 1:12 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, December 21, 2012 8:53 AM
Points: 244, Visits: 187

thanks.

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

Many thanks. Jeff

Post #868456

JeremyE

Posted Thursday, February 18, 2010 1:19 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:17 PM
Points: 2,392, Visits: 2,660

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

Gift Peddie

Posted Thursday, February 18, 2010 1:32 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

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 »

Permissions