• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

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

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
gtrapp
Asked:
gtrapp
  • 3
  • 2
1 Solution
 
dbaSQLCommented:
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
 
gtrappAuthor Commented:
I have VS 2003. Does VS 2003 convert them to 2005? I will have SSRS 2005 installed on the server.
0
 
dbaSQLCommented:
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
 
gtrappAuthor Commented:
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
 
dbaSQLCommented:
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

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now