I have a reporting setup with SSRS on our SQL Server 2005 database. Because SQL Server 2008 is not supported by the main program which populates our database we are stuck with 2005 on our production database. Unfortunately, when I run our weekly check reports the web interface constantly times out because the server can't do the conversion to PDF. I've read that SQL Server 2008's SSRS is A LOT better with memory management. I was wondering if I can do some kind transact log shipping subscription publication from 2005 to 2008? Am I chasing a dream here.
Currently I have to open up the SSRS project in Visual Studio and run the reports inside because it doesn't ever time out when doing the pdf conversion. It only times out if I try to run it through the SSIS web interface.