Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

What do I need to do with SQL Reprts 2000 to get them to work with SQL 2005?

Posted on 2008-06-09
5
Medium Priority
?
175 Views
Last Modified: 2010-03-19
I have some .rld files that were used with SQL Reporting Services 2000. Now, I like to move them over to SQL 2005. What are the steps to do this? Do I need to install Reporting Services 2005? Do I need to do any coversion with these .rld files so they can work with 2005 SSRS?
0
Comment
Question by:gtrapp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 21747661
not too much, they are very easily converted using visual studio -- you're in visual studio, solution explorer, right click the 'reports' folder, choose 'add existing item'
browse to your .rdl's, VS will tell you it needs to be converted, you click 'yes', or 'convert', or something of that nature ( i can't remember the exact dialog right now), and it converts it for you.

very easy.

i did it myself.  and i strongly encourage you to use SSRS 2005, as I think it would just be better using the later releases of both products
0
 

Author Comment

by:gtrapp
ID: 21747672
I have VS 2003. Does VS 2003 convert them to 2005? I will have SSRS 2005 installed on the server.
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 21747688
I cannot remember for certain, but very easy to confirm, though.  If you've got vs 2003 on the box and you are installing SSRS 2005, should be very easy to walk thru a conversion.

>>Now, I like to move them over to SQL 2005. What are the steps to do this? Do I need to install Reporting Services 2005?

but.  question for you -- why would you move the .rdl's to v2005 if you're not also doing the v2005 SSRS installation?  if at all possible, i would suggest sql and ssrs v2005, get that up to speed then you can confirm whether vs 2005 is required, too.
0
 

Author Comment

by:gtrapp
ID: 21747702
The data that the reports use are now in SQL 2005. They were getting the data from SQL 2000. Same database, but I move it all over to SQL 2005. This server is exposed to the public, as it is an Internet serer, with the internet site on it.
0
 
LVL 17

Accepted Solution

by:
dbaSQL earned 375 total points
ID: 21749964
In my opinion, I would get that sql/ssrs onto its own box.  comingling IIS along w/SQL is problematic, and risky, especially given that it is open to the public.  But.. that's your call.  I always try to keep my sql's dedicated, standalone instances, whenever possible.

Also in my opinion, go fully v2005 -- sql and ssrs -- it will only compliment things in the long run.  There are a number of new features/enhancements to SSRS 2005, that are not available in SSRS 2000.  If you want to take advantage of these new things, you need to convert them as I suggested above.

Oh, also, i've just confirmed you don't need VS 2005 to work w/SSRS v2005.  See here, there are a lot of very good pointers:  http://www.microsoft.com/sql/technologies/reporting/faq.mspx
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question