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
169 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
  • 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now