all groups > sql server reporting services > february 2007 >
You're in the

sql server reporting services

group:

Will SSRS 2005 work with SQL Server 2000 database?


Will SSRS 2005 work with SQL Server 2000 database? Jeff Stroope
2/28/2007 1:19:35 PM
sql server reporting services:
Hi,

My manager wants to upgrade from SSRS-2000 to SSRS-2005, but he doesn't want
to upgrade to SQL Server-2005 yet. Can we do this? Will SSRS-2005 work with
a SQL Server 2000 Reporting Services database/Report Catalog?

--
Thanks,

Re: Will SSRS 2005 work with SQL Server 2000 database? Jeff Stroope
2/28/2007 2:12:35 PM
Thanks Bruce! Can I bother you with one more question? I know that with
SSRS-2005, the report designer is actually part of reporting services and
visual studio is not required. Right now, I build the reports by using VS
2003. How does that work when you upgrade to SSRS-2005? Will we get the new
report designer, too?
--
Thanks,

Jeff


[quoted text, click to view]
Re: Will SSRS 2005 work with SQL Server 2000 database? Jeff Stroope
2/28/2007 3:44:03 PM
Thanks Bruce.
--
Thanks,

Jeff


[quoted text, click to view]
Re: Will SSRS 2005 work with SQL Server 2000 database? Bruce L-C [MVP]
2/28/2007 4:00:55 PM
Yes. It is a 100% supported (and this is how I first worked as well).


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Will SSRS 2005 work with SQL Server 2000 database? Bruce L-C [MVP]
2/28/2007 4:41:33 PM
When you install the new business intelligence tools it will install a
version of VS 2005 side by side with VS 2003. What you should do is copy
your directories with your source files to new directories. As you open up
the project in RS 2005 and then each individual report in the designer it
will convert them. It does not convert them until you open the report in the
designer. When you upgrade the server the existing reports are left in RS
2000 format. My suggestion is to open up all your reports and convert them
and redeploy. I had a variety of weird small problems when I upgraded that
went away once I did this.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services



[quoted text, click to view]

AddThis Social Bookmark Button