sql server reporting services: How to migrate ReportServer database from RS2000 to RS2005 -- sql server reporting services

You're in the

sql server reporting services

group:

How to migrate ReportServer database from RS2000 to RS2005

Nikola Milic
6/12/2006 12:00:00 AM

sql server reporting services: Hi,
BOL 2005 topic "Migrating report services" says that it is possible to
restore old, RS2000 ReportServer database to new RS2005. When I try to
Upgrade old ReportServer database by RS Configuration Manager, I get error
"There was a problem applying the database upgrade script".

What is wrong with Upgrade?

Thanks in advance
Nikola Milic

Re: How to migrate ReportServer database from RS2000 to RS2005

Nikola Milic
6/12/2006 4:43:37 PM

Hi,
To answer to myself, ReportServerTempDB should be restored as well (BOL
doesn't say anything about it).

But now I have another problem because RS cannot be initialized. What can be
wrong?

Regards
Nikola

[quoted text, click to view]

Re: How to migrate ReportServer database from RS2000 to RS2005

Nikola Milic
6/12/2006 9:01:49 PM

Hi again,
After restart, problem disappears by itself.

Conclusion, it is possible to migrate ALL data from RS 2000 to RS 2005 as
simple database restore, without any scripting tools.

Regards
Nikola

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

home · blog · groups

Questions? Comments? Contact the dn