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
173 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 125 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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

695 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