Moving SSRS Reports To Another Machine
I did a quick search on this topic and the ones I found had to do with moving the ReportServer database. I don't think that's what I need to do, but please correct me if Im wrong.I did a new SQL Server install (Database Engine and Reporting Services) on new machine and I would like to move over all the reports from the original machine to the new. What is the best way to do this?Now, when I did the new install, it obviously created the (1) msdb, (2) ReportServer, and (3) ReportServerTempDB. Typically, I don't do any work on these databases directly, but I know these have something to do with running SSRS. My approach was going to be, just leave these databases alone, and simply move over the report definitions to the new machine and whatever happens internally to (1) (2) (3) dbs will be taken care of by SQL Server.So what I started to do was open up my BIDS project that had all the report definitions and started to deploy the reports one by one to the new machine. I guess this is one way to do it manually, one report at a time. But I was wondering if there is a way to go from the original server to the new server via some auto generated script.
April 16th, 2010 7:29pm

How about this. I see that you can generate .rss script for each report. I did this and saved the rss file on the new machine. Then I executed the script in a command window like this.rs -i c:\blah\blah\blah.rss -s http://machine_name/ReportServerWhen I do this, I getUnhandled exception: The report definition is not valid. Details: Data at the root level is not valid. Line1, position 1.Is there something I need to edit in the rss file before I run this?
Free Windows Admin Tool Kit Click here and download it now
April 16th, 2010 9:19pm

Hi Doolin, try using this tool for migration, very handy and user-friendly http://www.sqldbatips.com/showarticle.asp?ID=62Cheers, Jason My Blog P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
April 17th, 2010 10:42am

You have 3 options here (1) First option is the one suggested by Jason. Really a good tool. I have used it few times to move the objects from one report server to another. (2) You can copy the Report Server database from the old server and restore it on the new server. You may have to adjust few config. for this. (3) Deploy from BIDs. Manual and also you need to take care of subscriptions, secutiy et.. I prefer the first option. Hassle free.
Free Windows Admin Tool Kit Click here and download it now
April 17th, 2010 11:03am

Thank you for the suggestion. I will look into the tool. However, while I was waiting for a reply, I decided to simply bring the production reports into BIDS and redeploy from BIDS to the new server.
April 19th, 2010 5:31pm

To undersntad the 3 options above. I created an image of the server and put it on the new server (newer/better). Now since we need to migrate over and have the latest data copied over what's the best option to go with? How do i copy over the report definition files alone or arethey stored in the report database so if i grab a new copy i would get the definitions updated on the new server?Almir
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2011 1:11am

I wrote this tool to help me sync between servers http://code.google.com/p/reportsync/ Just give it the source and destination servers and press sync This comes very handy if you many reports to be copied.
July 27th, 2011 1:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics