February 18, 2009 at 8:40 am
I have several dozen reports that need to be migrated from SQL 2000 Reporting Services to SQL 2008 SSRS. the migration path that i've been pointed toward is to redo each report individually using BIDS on SQL 2008.
i'm sure that a simple backup/restore of the reportserver and reportservertempdb databases would be too easy to expect, but is there a migration method to port these reports, or do they have to be recreated?
thanks.
October 8, 2010 at 8:37 am
You can try the following program
http://www.sqldbatips.com/showarticle.asp?ID=62
This will help you create a script for recreation.
August 31, 2013 at 8:02 am
Hi,
Please follow the below link that contains some steps that can be utilize for Report Migration:
http://www.sqlcircuit.com/2012/11/ssrs-different-ways-of-deploying-reports.html
Thanks,
Vishal
September 2, 2013 at 9:27 am
As long as your reports don't contain any custom code you can also move all of your reports by moving your report server database to the new server. Technet has a very good article including all the necessary scripts.
http://technet.microsoft.com/en-us/library/ms143724(v=sql.105).aspx
[font="Verdana"]Markus Bohse[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply