SQl Server Reporting Services - migrating 2000 to 2008

8 Jul 2009 11:19 AM

JaffaB

Hello All,

We are completing the process of migrating a SQL Server 2000 server to
SQL Server 2008. the last thing to do is migrate (or recreate) the
SQL Server reporting services reports.

Can anybody point me to any URLs or provide a guide on how we can
migrate the reports from our SQL Server 2000 server (physical box 1)
to our SQL Server 2008 server (physical box 2).

Many thanks in advance

Jaffa

8 Jul 2009 11:35 AM

Uri Dimant

hI
http://msdn.microsoft.com/en-us/library/ms143747.aspx

http://msdn.microsoft.com/en-us/library/ms144256.aspx

Show quoteHide quote

"JaffaB" <jaffa_br***@yahoo.co.uk> wrote in message
news:d9896f15-2c17-4647-a86f-19f787786834@c36g2000yqn.googlegroups.com...
> Hello All,
>
> We are completing the process of migrating a SQL Server 2000 server to
> SQL Server 2008. the last thing to do is migrate (or recreate) the
> SQL Server reporting services reports.
>
> Can anybody point me to any URLs or provide a guide on how we can
> migrate the reports from our SQL Server 2000 server (physical box 1)
> to our SQL Server 2008 server (physical box 2).
>
> Many thanks in advance
>
> Jaffa

8 Jul 2009 11:59 AM

JaffaB

Show quote Hide quote

On Jul 8, 12:35 pm, "Uri Dimant" <u***@iscar.co.il> wrote:
> hIhttp://msdn.microsoft.com/en-us/library/ms143747.aspx
>
> http://msdn.microsoft.com/en-us/library/ms144256.aspx
>
> "JaffaB" <jaffa_br***@yahoo.co.uk> wrote in message
>
> news:d9896f15-2c17-4647-a86f-19f787786834@c36g2000yqn.googlegroups.com...
>
> > Hello All,
>
> > We are completing the process of migrating a SQL Server 2000 server to
> > SQL Server 2008. the last thing to do is migrate (or recreate) the
> > SQL Server reporting services reports.
>
> > Can anybody point me to any URLs or provide a guide on how we can
> > migrate the reports from our SQL Server 2000 server (physical box 1)
> > to our SQL Server 2008 server (physical box 2).
>
> > Many thanks in advance
>
> > Jaffa
>
>

Thanks, but not really what I was after. this documents talk about
running the SQL Server upgrade wizard on a SQL Server 2000 server.
However, we want to move from server 1 (2000) to server 2 (2008). We
have moved selected databases (via backups and restores) and have
migrated the DTS's using the SSIS import wizard - but now want to
migrate (NOT upgrade) the reports.

8 Jul 2009 1:11 PM

Uri Dimant

JaffaB
Personally, I have not tried it, but what if you use BID to open SSRS and
then change the connection string for datasource and deploy to the new
location. I assume you have installed SSRS 2008 as well

Show quoteHide quote

"JaffaB" <jaffa_br***@yahoo.co.uk> wrote in message
news:643c4b14-6d44-4987-a673-06bba8c9a048@o7g2000yqb.googlegroups.com...
On Jul 8, 12:35 pm, "Uri Dimant" <u***@iscar.co.il> wrote:
> hIhttp://msdn.microsoft.com/en-us/library/ms143747.aspx
>
> http://msdn.microsoft.com/en-us/library/ms144256.aspx
>
> "JaffaB" <jaffa_br***@yahoo.co.uk> wrote in message
>
> news:d9896f15-2c17-4647-a86f-19f787786834@c36g2000yqn.googlegroups.com...
>
> > Hello All,
>
> > We are completing the process of migrating a SQL Server 2000 server to
> > SQL Server 2008. the last thing to do is migrate (or recreate) the
> > SQL Server reporting services reports.
>
> > Can anybody point me to any URLs or provide a guide on how we can
> > migrate the reports from our SQL Server 2000 server (physical box 1)
> > to our SQL Server 2008 server (physical box 2).
>
> > Many thanks in advance
>
> > Jaffa
>
>

Thanks, but not really what I was after. this documents talk about
running the SQL Server upgrade wizard on a SQL Server 2000 server.
However, we want to move from server 1 (2000) to server 2 (2008). We
have moved selected databases (via backups and restores) and have
migrated the DTS's using the SSIS import wizard - but now want to
migrate (NOT upgrade) the reports.