Moving reports to another server

Last Post 05 Sep 2006 10:55 AM by xfonhe. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Craig HB
New Member
New Member

30 Aug 2006 12:03 AM
We are moving all our web apps (including all the Reporting Services reports)
from Server 1 (SQL Server 2000) to Server 2 (SQL Server 2005).

What is the best way to move the reports from Server 1 to Server 2 ?

Is there anything special that I need to do, because they are now going to
be moved to Reporting Services 2005 ?

New Member
New Member

05 Sep 2006 10:55 AM
You can open the solution (.sln) from the original report server (SRS 2000) instance in SQL Server Business Intelligence Development Studio, which will convert it to a 2005 solution (you will be prompted).

Then simply deploy to the new server.

You could also attach the reports manually via Report Manager.... not recommended though, as this would be quite time consuming.

Acceptable Use Policy