April 20, 2012 at 11:59 am
I would like to upgrade SQL server 2005 reporting server to 2008 R2.
I read MS article : http://technet.microsoft.com/en-us/library/ms143674(v=sql.105).aspx
It says:
When you upgrade a SQL Server 2005 Reporting Services installation to a SQL Server 2008 Reporting Services installation, existing reports and snapshots that have been uploaded to a report server are automatically upgraded to the new schema the first time they are processed. If a report cannot be automatically upgraded, the report is processed using the backward-compatibility mode.
Existing report definition (.rdl) files are automatically upgraded when you open them in Report Designer in Business Intelligence Development Studio
So does this mean even we upgrade the reports, the devleoper still need to open their old version report in 2008 and save it and redeploy to the server?
Or we don't need developer to do that?
Thanks
April 20, 2012 at 1:13 pm
SQL Server 2008 introduces changes to the Report Definition Language (RDL), the report object model, and the rendering object model that affect reports created in earlier versions of the software. When you upgrade a SQL Server 2005 Reporting Services installation to a SQL Server 2008 Reporting Services installation, existing reports and snapshots that have been uploaded to a report server are automatically upgraded to the new schema the first time they are processed. If a report cannot be automatically upgraded, the report is processed using the backward-compatibility mode.
http://technet.microsoft.com/en-us/library/ms143674(v=sql.105).aspx
They should upgrade the first time you run them. Though you should do a test deployment, as I've heard there are changes including a sort order difference between 2008 and 2008 R2.
April 20, 2012 at 1:19 pm
Thank you, but my questions still not being answered.
I read the article, and I do have that link in my post too.
The article says the report is upgraded, but not the rdl files.
another place mentioned this, quoted:
"You can deploy an .rdl file created in an earlier version of Reporting Services to a SQL Server 2008 report server and it is automatically upgraded on first use. The report server stores the report definition file in the original format. The report is automatically upgraded the first time it is viewed, but the stored report definition file remains unchanged."
"The report definition itself is not upgraded on a report server. The compiled report is upgraded on a report server"
This is a little bit confusing to me. The report itself to me is rdl file, isn't it?
When we create a report, it saved in rdl file. But why it says the report is upgraded, but the rdl file which is report definition file keeps the original schema, and the only way to upgrade it is using BIDs, this lead me to think we also need developer to reopen 2005 reports in 2008, save it then redeploy it to server.
Thanks
April 20, 2012 at 2:13 pm
Any help please?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply