Wednesday, March 21, 2012

From RS2000 to RS2005. How to?

Hello,
I would appreciate if someone can advice me:
We are planning to migrate from Reporting Services 2000 (on old server) to new server with RS2005.
There are a lot of reports, few datasources and very complex security on folder and report levels.
As I understood all reports should be manually upgraded (click and deploy), but what with datasources,
folder structure and security roles?
Kind regards,
ZoranHi,
There is a free Reporting Services scripting tool "Reporting Services
Scripter" http://www.sqldbatips.com/showarticle.asp?ID=62.
You can script folders' structure using this tool and folders' security
(including data sources folders) and then you can deploy you upgraded reports.
You will need to reenter passwords for the data sources.
"Zoran" wrote:
> Hello,
> I would appreciate if someone can advice me:
> We are planning to migrate from Reporting Services 2000 (on old server) to new server with RS2005.
> There are a lot of reports, few datasources and very complex security on folder and report levels.
> As I understood all reports should be manually upgraded (click and deploy), but what with datasources,
> folder structure and security roles?
> Kind regards,
> Zoran
>

No comments:

Post a Comment