Develop both SQL Server 2008 and SQL Server 2008R2 reports on same dev box

Question

We have a large real-estate of existing SSRS 2008 reports that we are still maintain in production.
However we are evaluating SSRS 2008r2 and would like to start developing reports that take advantage of the new features such as shared datasets etc.

The problem is that AFAIK installing the tools for 2008R2 upgrades the Visual Studio 2008 tools from 2008 to 2008R2. This means that when you open a 2008 report and make any changes that it thinks need a new feature it upgrades the schema to R2 making it incompatible with our production servers.

Has anyone else encountered this? Any tips? I don't want to RDP to a VM or anything nasty like that really.

Answer 1

Some things get upgraded, others remain specific to the instance. For example, Business Intelligence Design Studio gets upgraded, but Reporting Services remains independent. See this link for a complete discussion: http://msdn.microsoft.com/en-us/library/ee210714.aspx

Answer 2

I've just realised it's possible to install Report Builder 2.0 alongside Report Builder 3.0 and Visual Studio 2008 with SQL 2008r2 tools in it.

Thus I can at least edit the old .RDLs using Report Builder 2.0. I hope someone has a better solution.