Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

Move SSRS 2005 to new server running SSRS 2008R2

I'd like to move our reports server along with all the reports etc.. to a new server running SSRS 2008 R2

Any information would be great.
0
fluk3d
Asked:
fluk3d
  • 3
  • 2
2 Solutions
 
planoczCommented:
all the reports have to be re-deployed to the new server.
0
 
fluk3dAuthor Commented:
Ok, can you provide a bit more explanation on why they have to be redeployed and how I can redeploy them?
0
 
planoczCommented:
You can use a report writer or BIDS on Visual Studio 2008. open the files and deploy them to your new directory. If you are going to use 2005 you will have to deploy them to 2008 so that the reporting services can upgarde them to 2008 code.
0
 
fluk3dAuthor Commented:
Used the following tool to script the reports, and then re-deploy them into the current ssrs server.

http://www.sqldbatips.com/showarticle.asp?ID=62
0
 
fluk3dAuthor Commented:
Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now