dbTalk Databases Forums  

SQl Server Reporting Services - migrating 2000 to 2008

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss SQl Server Reporting Services - migrating 2000 to 2008 in the microsoft.public.sqlserver.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JaffaB
 
Posts: n/a

Default SQl Server Reporting Services - migrating 2000 to 2008 - 07-08-2009 , 06:19 AM






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

Reply With Quote
  #2  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQl Server Reporting Services - migrating 2000 to 2008 - 07-08-2009 , 06:35 AM






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

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




"JaffaB" <jaffa_brown (AT) yahoo (DOT) co.uk> wrote

Quote:
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

Reply With Quote
  #3  
Old   
JaffaB
 
Posts: n/a

Default Re: SQl Server Reporting Services - migrating 2000 to 2008 - 07-08-2009 , 06:59 AM



On Jul 8, 12:35*pm, "Uri Dimant" <u... (AT) iscar (DOT) co.il> wrote:
Quote:
hIhttp://msdn.microsoft.com/en-us/library/ms143747.aspx

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

"JaffaB" <jaffa_br... (AT) yahoo (DOT) co.uk> wrote in message

news:d9896f15-2c17-4647-a86f-19f787786834 (AT) c36g2000yqn (DOT) 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.

Reply With Quote
  #4  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQl Server Reporting Services - migrating 2000 to 2008 - 07-08-2009 , 08:11 AM



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




"JaffaB" <jaffa_brown (AT) yahoo (DOT) co.uk> wrote

On Jul 8, 12:35 pm, "Uri Dimant" <u... (AT) iscar (DOT) co.il> wrote:
Quote:
hIhttp://msdn.microsoft.com/en-us/library/ms143747.aspx

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

"JaffaB" <jaffa_br... (AT) yahoo (DOT) co.uk> wrote in message

news:d9896f15-2c17-4647-a86f-19f787786834 (AT) c36g2000yqn (DOT) 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.

Reply With Quote
  #5  
Old   
CodeGeek
 
Posts: n/a

Default RE: SQl Server Reporting Services - migrating 2000 to 2008 - 07-20-2009 , 11:34 AM



http://msdn.microsoft.com/en-us/library/ms143724.aspx should point you in the
right direction.

"JaffaB" wrote:

Quote:
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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.