sql server reporting services: From RS2000 to RS2005. How to? -- sql server reporting services

From RS2000 to RS2005. How to?

Zoran
5/26/2006 5:24:21 AM

sql server reporting services: 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,

RE: From RS2000 to RS2005. How to?

Magas
6/5/2006 10:00:02 AM

Hi,
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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.