Showing posts with label applications. Show all posts
Showing posts with label applications. Show all posts

Tuesday, March 20, 2012

RS2000 & internal RS Database in SQL 2005

Dear all,
We are migrating step by step our different environements, we would like to
migrate SQL 2005 first, then migrate all the other applications to .NET v2.0,
Reporting Services 2005, ...etc.
We already bought the new SQL 2005 servers and we have several questions
about this :
- Could Reporting Services 2000 that is installed in the Web Servers have
internal Reporting Services Databases that are installed in SQL 2005?
- Is it supported by Microsoft? if so could yoiu please indicate a link to
Microsoft Web site confirming this?
- In order to point to the new databases do we have to uninstall RS 2000
and then install it again on the same machine and pointing to the new Servers
OR can I use rsconfig.exe to change the server and create the Reporting
Services Databases?
Best regards,
Stefan
http://www.itsconsulting.frAny response to my question above?
How can I get this information?
Stefan|||I know that RS 2005 can have its databases on SQL 2000 (and is fully
supported). I do not think that it is supported the other way. My guess is
that it will do a version check of the database and complain. However, would
RS 2000 continue working if you upgraded the database? Probably, but I don't
think it is officially supported.
When you get around to migrating RS 2000 a bit of advice. When you upgrade
the server the reports are still in RS 2000 format. They will continue to
work but I had the case with a few weird little problems here and there.
When I opened each report into the RS 2005 designer and converted them to RS
2005 format and redeployed, all my little problems disappeared.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stefan" <Stefan@.discussions.microsoft.com> wrote in message
news:11DF485F-901E-4A81-9B85-813F93DE3CF3@.microsoft.com...
> Dear all,
> We are migrating step by step our different environements, we would like
> to
> migrate SQL 2005 first, then migrate all the other applications to .NET
> v2.0,
> Reporting Services 2005, ...etc.
> We already bought the new SQL 2005 servers and we have several questions
> about this :
> - Could Reporting Services 2000 that is installed in the Web Servers have
> internal Reporting Services Databases that are installed in SQL 2005?
> - Is it supported by Microsoft? if so could yoiu please indicate a link to
> Microsoft Web site confirming this?
> - In order to point to the new databases do we have to uninstall RS 2000
> and then install it again on the same machine and pointing to the new
> Servers
> OR can I use rsconfig.exe to change the server and create the Reporting
> Services Databases?
> Best regards,
> Stefan
> http://www.itsconsulting.fr
>