Last post Mar 24, 2015 10:41 PM by Edwin Guru Singh
Mar 24, 2015 01:44 AM|yogeshweb|LINK
Hi, i have deployed the Report in SQL 2005 server.
i have deleted all the .rdl files now i want to make some changes in the reports which are deployed on SQL Server 2005.
any idea how can i retrieve my .rdl files?
and i also want to migrate these report from SQL 2005 to SQL 2008 Server.
Mar 24, 2015 10:41 PM|Edwin Guru Singh|LINK
As per your case, I have shared my ideas below :
Not sure about deleted files whether we can possible to retrieve or not. However, you can try the following steps:
1.Go to the Report Manager
2.Click on the report
3.Go to the Properties tab on the top
4.Click on Edit in the Report Definition section to download.
The migration is pretty straight forward when moving from SSRS 2005 to SSRS 2008. Just backup the ReportServer and ReportServerTempdb from 2005 and restore them
to 2008, then point RS 2008 at them. RS 2008 will migrate the schema for you. You will need to create the RSExec role first and don't forget to backup and
then restore the encryption key. See the link below for some considerations
make sure your data sources do not have spaces in them prior to upgrading from 2005 to 2008. RS 2008 will replace the spaces with an underscore and all reports
depending on the data source will break. It's best to fix this prior to the migration