Migrate Reports to new server and new db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

trnsfrmrsr - 10 Jul 2008 00:00 GMT

I've got reporting services reports sitting on SSRS 2000 and report on a
(semi-broken) SSRS2005 server. At this point we'd like to just create a new
SSRS 2005 server (which uses new DBs) and move the reports from both servers
to the new server.

Is there a way to migrate reports from both SSRS versions to a new server?

Reply to this Message

Jason Wilson - 15 Jul 2008 16:06 GMT

You can use the tool at the website below. You basically point it toward you
current server, it will go through and script out everything that you tell it
to to files, and generate a .bat file you can then point the .bat file to
your new server, and it will run the scripts on your new server and deploy
the stuff it scripted off your old server to the new server. Very handy, and
free.

http://www.sqldbatips.com/showarticle.asp?ID=62

Thanks,

Jason

> I've got reporting services reports sitting on SSRS 2000 and report on a
> (semi-broken) SSRS2005 server. At this point we'd like to just create a new
> SSRS 2005 server (which uses new DBs) and move the reports from both servers
> to the new server.
>
> Is there a way to migrate reports from both SSRS versions to a new server?

Reply to this Message