Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 11:59 AM
Points: 147, Visits: 360
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.

Thanks,

Tom
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: Today @ 11:23 AM
Points: 4,389, Visits: 9,528
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: http://www.sqldbatips.com/showarticle.asp?ID=62

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 opportunites 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