Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Where are report (.rds files) stored Expand / Collapse
Posted Tuesday, June 7, 2011 7:25 PM


Group: General Forum Members
Last Login: 2 days ago @ 6:38 PM
Points: 190, Visits: 453
In the Report Manager, I create folders but need to move the rds and rdl files I created manually. But I can't figure out where the folders are so I can move the files.

I need to move them from my development server to my production server and need to do it by hand.


Post #1121478
Posted Tuesday, June 7, 2011 8:29 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:06 AM
Points: 4,377, Visits: 9,710
They are stored in the database - not in the file system.

Your options are:

1) Use BIDS and deploy to the new system
2) Use a tool that will move it for you.

There is a tool available here:

If you have to do this 'manually' without being able to use the above tool, then I would recommend the following:

From Report Manager - list the folder/reports in detail mode. From detail mode, select the option to edit the report properties. On that page, you have an option to edit/update the report. Select the option to edit - this will allow you to save the report (rdl) file to the file system.

Once you have all of the reports in a folder on the file system, open BIDS and create a new project. In that project, add existing item - from the folder you created to hold the RDL files. Repeat until you have added all reports.

Configure the project to deploy to the new report server and deploy.

Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #1121490
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse