sql server reporting services: Upgrading RS2000 Reports to RS2005 -- sql server reporting services

Upgrading RS2000 Reports to RS2005

Sajal Kumar
10/17/2006 8:18:01 AM

sql server reporting services: Dear RS Experts,

In upgrading the 2000 reports in 2005 Reports Manager, i was able to upload
the rdl file. But it did not bring its data source with it. I do not see any
option to upload the old datasource. do they have to be created fresh for
each report and linked to the report? that is what i had to do.
Is there a command line interface to upgrade the reports in bulk because, it
can be quite painful upgrading one at a time.

Appreciate your help.

Regards,
Sajal.

Re: Upgrading RS2000 Reports to RS2005

Sajal Kumar
10/17/2006 12:30:02 PM

Immy, thanks much. It looks like i was not configuring RS2005 properly upon
restoring the databases on 2005 from 2000 SQL Server instance. The reports
and data sources all showed up. i did not have to do anything.

Sajal.

[quoted text, click to view]

Re: Upgrading RS2000 Reports to RS2005

Immy
10/17/2006 4:25:22 PM

Afraid you have to do each one manually. It's a pain, I agree!
As for your datasource issue, I didnt encounter any problems from what I
remember.
Out of interest, have you seen this article?
http://msdn2.microsoft.com/en-us/library/ms143747.aspx

Immy

[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.