RDL managment

Pretty much we all know that you can use SSRS to manage your reports, but when it comes to transfering rdls that (2005/2008) limits you to one rdl at a time.

Were you aware that the RDL files are actually stored as XML inside the Reports database? and you can query them straight out of the database:

SELECT [Path], [Name], SourceCode = CAST(CAST(content AS VARBINARY(max)) AS XML)
FROM ReportServer.dbo. Catalog
WHERE Type IN (2,6 )
ORDER BY Path, Type, Name

You can also use some third party tools (nice for keeping the folder structure of the reports) to either download the rdls or transfer rdls from one server to another.

http://www.sqldbatips.com/showarticle.asp?ID=62