Hi All,
I am trying to migrate my SSRS reports from SQL Server 2005 Environment to SQL Server 2008 R2.
As I already have some set of new reports(reports which are not in 2005 Environment) exists in 2008 R2 Environment, I cannot migrate
the reports using a standard approach of taking the Backup of ReportServer database from 2005 Server and restoring it to an SQL Server
2008 R2,which will replace all the reports existing in 2008 R2 Environment and i only get a copy of 2005 reports in 2008 R2 Envrionment.
Hence I am trying to use Reporting Services Scripter Tool from this link(http://www.sqldbatips.co/showarticle.asp?ID=62 ) for moving my
report server objects from 2005 environment to 2008 R2 and using this i am able to move all my reports,Datasource,subscription,roles successfully.
But i have an issue in moving my
Data Driven File Share Subscriptions which is throwing the below exception. Error : rsDeliveryError (A subscription delivery error has occurred.)
If any one of you moved the Report server objects from 2005 to 2008 R2 using the RSS Scripter tool,
Please suggest me how to move Data Driven File Share Subscription from SQL Server 2005 to SQL Server 2008 R2
Lokesh Reddy
Member
56 Points
56 Posts
SSRS 2005 to 2008 R2 migration using RS Scripter tool
Feb 08, 2013 07:48 AM|LINK
Hi All,
I am trying to migrate my SSRS reports from SQL Server 2005 Environment to SQL Server 2008 R2.
As I already have some set of new reports(reports which are not in 2005 Environment) exists in 2008 R2 Environment, I cannot migrate the reports using a standard approach of taking the Backup of ReportServer database from 2005 Server and restoring it to an SQL Server 2008 R2,which will replace all the reports existing in 2008 R2 Environment and i only get a copy of 2005 reports in 2008 R2 Envrionment.
Hence I am trying to use Reporting Services Scripter Tool from this link(http://www.sqldbatips.co/showarticle.asp?ID=62 ) for moving my report server objects from 2005 environment to 2008 R2 and using this i am able to move all my reports,Datasource,subscription,roles successfully.
But i have an issue in moving my Data Driven File Share Subscriptions which is throwing the below exception.
Error : rsDeliveryError (A subscription delivery error has occurred.)
If any one of you moved the Report server objects from 2005 to 2008 R2 using the RSS Scripter tool,
Please suggest me how to move Data Driven File Share Subscription from SQL Server 2005 to SQL Server 2008 R2