x

Reporting services Upgrade

Hi I wonder if someone can advise me.

I wrote a bunch of reports in Visual Studio 2008 and then my local Dev Server got upgraded to SQL 2008 R2 from SQL 2008. Now Visual Studio is saying I need to upgrade my projects from within BIDS.

I haven't upgrade the server the reports are being deployed to and I'm concerned about a compatibility issue.

Is this expected?

Many thanks
more ▼

asked Feb 02, 2012 at 03:16 PM in Default

Mrs_Fatherjack gravatar image

Mrs_Fatherjack
4.7k 60 62 66

+1 good question. I know they definitely broke between 2005 and 2008, but 2008 and R2 - I wouldn't like to guess ....
Feb 02, 2012 at 03:35 PM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

Yes there are some compatibility issues. Like to downgrade the 2008 R2 edited Report back to 2008, this person's article helped quite a few ( it took some time to search it again )

So, If you save a SQL Server 2008 Report Server project in the SQL Server 2008 R2 version Business Intelligence Development Studio you can no longer open it in the SQL Server 2008 version of Business Intelligence Development Studio.

But at the same time, You can use the SQL Server 2008 R2 version of Business Intelligence Development Studio to open, modify, preview, save, and deploy both SQL Server 2008 and SQL Server 2008 R2 Reporting Services reports. This makes it easy to work with both earlier and later versions of reports and Report Server projects by using the later version of Business Intelligence Development Studio.

The SQL Server 2008 R2 version of Business Intelligence Development Studio supports the following scenarios:

  • Opening SQL Server 2008 and SQL Server 2008 R2 versions of report definitions and report server projects.

  • Building report definitions that are compatible with both SQL Server 2008 and SQL Server 2008 R2 Reporting Services.

  • Previewing SQL Server 2008 and SQL Server 2008 R2 Reporting Services reports in Report Designer.

  • Deploying reports to report servers running either SQL Server 2008 Reporting Services or SQL Server 2008 R2 Reporting Services.

Hence, now unlike the old days, where there were cases of having BIDS 2000, 2005 and 2008 on the same machine, now we can live with SQL 2008 R2 only if we do have SQL 2008 and 2008R2 to work with.

For detailed information, please visit this link

more ▼

answered Feb 03, 2012 at 05:33 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

Many thanks
Feb 03, 2012 at 10:01 AM Mrs_Fatherjack
Who down-voted this and didn't add a comment? Please do not down-vote without some indication of why this is/isn't a good answer.
Feb 03, 2012 at 10:25 AM Kev Riley ♦♦
I can assure you it wasn't me :)
Feb 03, 2012 at 10:53 AM Usman Butt
I voted it up!!
Feb 03, 2012 at 02:50 PM Mrs_Fatherjack
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1846
x558
x35
x9

asked: Feb 02, 2012 at 03:16 PM

Seen: 1448 times

Last Updated: Feb 29, 2012 at 02:37 PM