Hi, I am moving from SQL server 2000 to SQL server 2005. I'am also moving to the new Reporting services 2005. There are almost 400 reports and like 100 subscriptions under the actual configuration. I have imported the reports but I don't know how to recreate the subscriptions.
Any ideas?
Thanks,
Alejandro Gutierrez.
It sounds like to did not upgrade, but you are rather trying to migrate the contents to RS 2005. You could move the subscriptions for instance by making SOAP calls to retrieve the settings from one server and apply them on the other server.
A tool I found quite useful for performing this kind of job is Jasper Smith's RS Scripter: http://www.sqldbatips.com/showarticle.asp?ID=62
-- Robert
|||Yes, I'm migrinting to another server. That tool seems pretty cool. I'm going to give it a try. Thanks a bunch !!!
Alejandro.l
sql
No comments:
Post a Comment