November 22, 2011 at 3:28 am
Hi,
Planning to upgrade. so question is, if someone has already tested:
Can 2012 RDL points to SQL DB 2008 data source?
Can 2008 RDL points to SQL DB 2012(denali) data source?
Can 2005 RDL points to SQL DB 2012(denali) data source?
Can we deploy 2012 RDL to 2008? and vice versa?
Thanks.
November 22, 2011 at 7:39 am
I may be wrong, but I don't think the data source matters, where the report is deployed is what matters. You could probably deploy a 2005 rdl to a 2008 or higher server, but you probably can't deploy a 2012 report to an earlier version server.
However, if you have a 2005 rdl you won't have the ability to use any BIDS or T-SQL features that are not available on 2005. You may be able to use some T-SQL features available on the newer server if you encapsulate your code inside a stored procedure on the newer server and then just call the data from the stored procedure.
There are enough potential pitfalls in this process I recommend that you spend more time with the proper documents and white papers for your answers rather than rely on forum responses.
November 22, 2011 at 10:15 am
Thanks Daniel,
I may be wrong, but I don't think the data source matters, where the report is deployed is what matters. You could probably deploy a 2005 rdl to a 2008 or higher server, but you probably can't deploy a 2012 report to an earlier version server.
. Correct just tested this.
However, if you have a 2005 rdl you won't have the ability to use any BIDS or T-SQL features that are not available on 2005. You may be able to use some T-SQL features available on the newer server if you encapsulate your code inside a stored procedure on the newer server and then just call the data from the stored procedure.
Agreed.
What i have tested today is:
1: Made a report in "BIDS Denali 2012" deployed on 2012, 2008 and works fine but cannot deploy same report on 2005 and got following error.
"The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition) Get Online Help"
2: Pointed report from 2005 server to 2008 and 2012 database source without any problem and also vice versa. so Database source is definitely not a problem.
There are enough potential pitfalls in this process I recommend that you spend more time with the proper documents and white papers for your answers rather than rely on forum responses.
Yes i do agree with this point and i am already reading and testing things in parallel. That's why i am sharing my thoughts if someone has already went through this testing then fine.
What i have learned so far is that 2008 and 2012 don't have any problem while creating and deploying any report on each other. Only point is that one need to make sure that the feature you are using is available on sever where you are deploying.
Do you know any link which compares/tells that which features of SSRS are available in which version of sql server (2005/2008/2012) and which are not?
Thanks.
November 22, 2011 at 10:23 am
November 23, 2011 at 5:45 am
Thanks Revenant,
But i want SSRS feature comparison by Version, if someone has seen somewhere.
Thanks.
November 23, 2011 at 9:46 am
Surprisingly, there is no version diff article on MSDN or TechNet.
This is IMO worth reading: http://www.simple-talk.com/sql/reporting-services/new-features-in-reporting-services-2008-and-2008-r2/
IN 2012, you will get a vastly improved PowerPivot with new report galleries, and new Data Alerts.
Since 2012 was declared RTM last Friday, I expect that articles on the new feature will start popping up.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply