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

SSRS Migration tool like SSIS package upgrade wizard Expand / Collapse
Author
Message
Posted Friday, July 18, 2014 8:14 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 3, 2014 12:13 PM
Points: 66, Visits: 168
Hello and Happy Friday!

I have been searching for a migration tool for SSRS that is similar to the SSIS package upgrade wizard. I am running a simulated migration with a VM box to prepare for our actual upgrade. Unfortunately, I have not found any decent tools that assist with moving reports and subscriptions. It seems the only way to do this is to back up and restore the reporting databases and manually add and open each report to report manager (I have 100+ reports, so I am not looking forward to that).

The following Microsoft tool does what I want, but it only works for 2008 R2 - current. I am migrating from 2005.

http://www.microsoft.com/en-us/download/details.aspx?id=29560

Any guidance on this issue would be appreciated!

SQL-TG


_________________________________________________________________________
- "Imagination is more important than knowledge" --Albert Einstein
Post #1594079
Posted Wednesday, July 23, 2014 6:09 AM This worked for the OP Answer marked as solution
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 8:21 AM
Points: 213, Visits: 780
Hi,

The best tool for the job in my opinion is rsscripter, this was written by an MVP and should allow you to copy reports and subscriptions from one server to another and most importantly is compatible with most of the different versions of SSRS.

http://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20Reporting%20Services%20Scripter

HTH
Post #1595447
Posted Thursday, July 24, 2014 8:59 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 3, 2014 12:13 PM
Points: 66, Visits: 168
Yea, I saw this but I was wondering if MS had anything else. Surprising that the tool MS offers is only compatible with 2008 R2 and higher. One would think that due to the major differences between SSRS 2005 and 2008, that they would create a tool for an easier migration.

Thank you for the clarification.


_________________________________________________________________________
- "Imagination is more important than knowledge" --Albert Einstein
Post #1595925
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse