posted 7/12/2012 by sqlscottgleason - Views: [650]
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. CatalogWHERE 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