Moving reports and their histories from SQL2000-RS to SQL2005-RS

I have SQL 2000 Reporting Server with 30+ reports scheduled to be generated periodically and their snapshots are maintained in respective report history. Few weeks ago; we got SQL 2005 Reporting Server and we started using it for all the new work.

Now we want to retire the old SQL 2000 RS machine but wants to copy the reports along with their histories on to the new server. Can someone guide or give pointers where I can find information on this topic?

Preserving report histories is very critical. Report generation schedule may be re-configured.

You could (backup and then) directly upgrade your existing RS 2000 installation.

Alternatively, you can backup the encryption keys and the ReportServer / ReportServerTempDB of the RS 2000 installation, and move them to another database server. Then install a new RS 2005 instance (with a files-only install). Finally, you can use the RS configuration tool to point the RS 2005 instance to the old databases, upgrade them to the RS 2005 schema and also apply the encryption keys. You can find more information about this in BOL - specifically under migrating Reporting Services: http://msdn2.microsoft.com/en-us/library/ms143724.aspx

-- Robert

|||

Thanks Robert for the reply, the glitch is; the SQL2k5-RS instance where I wish to have my older reports; is already in use for few weeks now.

If we “upgrade” SQL2k-RS to SQL2k5-RS; can we then be able to “migrate” reports from one SQL2k5-RS instance to another SQL2k5-RS instance? (Along with report histories; as its critical)

|||

In that case you may want to look at the RSScripter tool: http://www.sqldbatips.com/showarticle.asp?ID=62

It can definitely move reports, security settings, and subscription settings. I'm not sure about history snapshots though.

-- Robert

|||

I have checked that tool; and my understanding is; that it doesnt copy/script the report histories. However one can script history/execution setting.

I have not gone through Report Server API (Web Services); but can we retreive report history instances (snapshots) using it?