Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

report migration question

Status
Not open for further replies.

mjp483

Programmer
Apr 27, 2004
42
US

Does anyone know an easy way to get all the rdl's from a report server in one fell swoop? I am looking for the physical file, report name, and directory where it is displayed. Ultimately, we are moving rdl's from one server to another and need to physically move the rdl's.




 
Did you try querying the ReportServer database?

The following query will give you a list of all reports on the server:
[tt]
SELECT
SUBSTRING(C.[Path],1, LEN(C.[Path])-LEN(C.[Name])-1) as 'ItemPath',
C.[Name] as 'ItemName'
FROM
[Catalog] C
WHERE
Type in (2,4)
ORDER BY ItemPath[/tt]

... poke around to get the other things you need but remember only SELECT... don't UPDATE, INSERT, DELETE, or DROP anything or you could mess it up.
 


Do you have any idea where the RDL is stored? Someone told me it was in a table..?? It's hard for me to believe the RDL isn't somewhere where I can get it.
 


I guess you need to write a web service to extract the rdl files.
 
Sheco,

Your code only gives the webpage path. It doesn't give the logical hard drive path which mjp483 is looking for.

Mjp483, try looking doing a search on that box for *.rdl. Though, I'm not sure the actual .rdl files are physically stored as files on the RS box. It may be that all the definitions are stored in the ReportServer database.

Do you guys not have the reports saved in SourceSafe or some other such program?



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top