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
166 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
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…

772 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

10 Experts available now in Live!

Get 1:1 Help Now