« August 2008 | Main | October 2008 »
September 29, 2008
quot
#160;
by Shruti Sinha, Project Manager
With SQL Server 2008 finally a real option for organizations, IT departments need to address bottom line tactical operational issues before deployment. Questions they need to address are #8211; will my legacy applications still work as expected or do I need to reinvest and redeploy everything.
The table below answers some of these questions.
| Usage Scenario | Support Statement |
| Applications built for RS 2005, 2005 SP2 | Will work |
| Applications built for RS 2000 | RS 2000 SOAP APIs are not supported |
| RS 2005 RDL, RS 2000 RDL | URL access will work Can publish Cannot edit |
| RS Database hosted in SQL 2005 | Will work |
| RS Database hosted in SQL 2000 | Not supported |
| VS 2005 ReportViewer Control | Supported |
| SharePoint integration | Supported |
| SharePoint v2 WebParts | Supported |
Similarly when upgrading to SSRS 2008 here are some things to remember
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 server WILL support running legacy RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2005 RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2000 RDL
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 designer has PARTIAL support for legacy RDL
#8211;#160;#160;#160;#160;#160;#160; Converts legacy RDL to 2008 RDL
#8211;#160;#160;#160;#160;#160;#160; If you don#8217;t convert, you cannot open the RDL in the 2008 designer
#8211;#160;#160;#160;#160;#160;#160; CANNOT save to legacy RDL formats
#8226;#160;#160;#160;#160;#160;#160;#160; Published reports upgrade on the fly
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 RDL will NOT work with SQL 2005
#8226;#160;#160;#160;#160;#160;#160;#160; SQL 2005 Report Engine is deprecated
#8211;#160;#160;#160;#160;#160;#160; Snapshots created in 2000 or 2005 WORK in SQL 2008
#8211;#160;#160;#160;#160;#160;#160; They will not work in a version after 2008
Posted by Steve Mann at 3:44 PM | Comments (0)
quot
#160;
by Shruti Sinha, Project Manager
With SQL Server 2008 finally a real option for organizations, IT departments need to address bottom line tactical operational issues before deployment. Questions they need to address are #8211; will my legacy applications still work as expected or do I need to reinvest and redeploy everything.
The table below answers some of these questions.
| Usage Scenario | Support Statement |
| Applications built for RS 2005, 2005 SP2 | Will work |
| Applications built for RS 2000 | RS 2000 SOAP APIs are not supported |
| RS 2005 RDL, RS 2000 RDL | URL access will work Can publish Cannot edit |
| RS Database hosted in SQL 2005 | Will work |
| RS Database hosted in SQL 2000 | Not supported |
| VS 2005 ReportViewer Control | Supported |
| SharePoint integration | Supported |
| SharePoint v2 WebParts | Supported |
Similarly when upgrading to SSRS 2008 here are some things to remember
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 server WILL support running legacy RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2005 RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2000 RDL
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 designer has PARTIAL support for legacy RDL
#8211;#160;#160;#160;#160;#160;#160; Converts legacy RDL to 2008 RDL
#8211;#160;#160;#160;#160;#160;#160; If you don#8217;t convert, you cannot open the RDL in the 2008 designer
#8211;#160;#160;#160;#160;#160;#160; CANNOT save to legacy RDL formats
#8226;#160;#160;#160;#160;#160;#160;#160; Published reports upgrade on the fly
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 RDL will NOT work with SQL 2005
#8226;#160;#160;#160;#160;#160;#160;#160; SQL 2005 Report Engine is deprecated
#8211;#160;#160;#160;#160;#160;#160; Snapshots created in 2000 or 2005 WORK in SQL 2008
#8211;#160;#160;#160;#160;#160;#160; They will not work in a version after 2008
Posted by Steve Mann at 3:44 PM | Comments (0)
quot
#160;
by Shruti Sinha, Project Manager
With SQL Server 2008 finally a real option for organizations, IT departments need to address bottom line tactical operational issues before deployment. Questions they need to address are #8211; will my legacy applications still work as expected or do I need to reinvest and redeploy everything.
The table below answers some of these questions.
| Usage Scenario | Support Statement |
| Applications built for RS 2005, 2005 SP2 | Will work |
| Applications built for RS 2000 | RS 2000 SOAP APIs are not supported |
| RS 2005 RDL, RS 2000 RDL | URL access will work Can publish Cannot edit |
| RS Database hosted in SQL 2005 | Will work |
| RS Database hosted in SQL 2000 | Not supported |
| VS 2005 ReportViewer Control | Supported |
| SharePoint integration | Supported |
| SharePoint v2 WebParts | Supported |
Similarly when upgrading to SSRS 2008 here are some things to remember
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 server WILL support running legacy RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2005 RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2000 RDL
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 designer has PARTIAL support for legacy RDL
#8211;#160;#160;#160;#160;#160;#160; Converts legacy RDL to 2008 RDL
#8211;#160;#160;#160;#160;#160;#160; If you don#8217;t convert, you cannot open the RDL in the 2008 designer
#8211;#160;#160;#160;#160;#160;#160; CANNOT save to legacy RDL formats
#8226;#160;#160;#160;#160;#160;#160;#160; Published reports upgrade on the fly
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 RDL will NOT work with SQL 2005
#8226;#160;#160;#160;#160;#160;#160;#160; SQL 2005 Report Engine is deprecated
#8211;#160;#160;#160;#160;#160;#160; Snapshots created in 2000 or 2005 WORK in SQL 2008
#8211;#160;#160;#160;#160;#160;#160; They will not work in a version after 2008
Posted by Steve Mann at 3:44 PM | Comments (0)
Nice to Know Tidbits for SSRS 2008 Deployment and SSRS 2008 Upgrades
#160;
by Shruti Sinha, Project Manager
With SQL Server 2008 finally a real option for organizations, IT departments need to address bottom line tactical operational issues before deployment. Questions they need to address are #8211; will my legacy applications still work as expected or do I need to reinvest and redeploy everything.
The table below answers some of these questions.
| Usage Scenario | Support Statement |
| Applications built for RS 2005, 2005 SP2 | Will work |
| Applications built for RS 2000 | RS 2000 SOAP APIs are not supported |
| RS 2005 RDL, RS 2000 RDL | URL access will work Can publish Cannot edit |
| RS Database hosted in SQL 2005 | Will work |
| RS Database hosted in SQL 2000 | Not supported |
| VS 2005 ReportViewer Control | Supported |
| SharePoint integration | Supported |
| SharePoint v2 WebParts | Supported |
Similarly when upgrading to SSRS 2008 here are some things to remember
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 server WILL support running legacy RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2005 RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2000 RDL
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 designer has PARTIAL support for legacy RDL
#8211;#160;#160;#160;#160;#160;#160; Converts legacy RDL to 2008 RDL
#8211;#160;#160;#160;#160;#160;#160; If you don#8217;t convert, you cannot open the RDL in the 2008 designer
#8211;#160;#160;#160;#160;#160;#160; CANNOT save to legacy RDL formats
#8226;#160;#160;#160;#160;#160;#160;#160; Published reports upgrade on the fly
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 RDL will NOT work with SQL 2005
#8226;#160;#160;#160;#160;#160;#160;#160; SQL 2005 Report Engine is deprecated
#8211;#160;#160;#160;#160;#160;#160; Snapshots created in 2000 or 2005 WORK in SQL 2008
#8211;#160;#160;#160;#160;#160;#160; They will not work in a version after 2008
Posted by Steve Mann at 3:44 PM | Comments (0)
Nice to Know Tidbits for SSRS 2008 Deployment and SSRS 2008 Upgrades
#160;
by Shruti Sinha, Project Manager
With SQL Server 2008 finally a real option for organizations, IT departments need to address bottom line tactical operational issues before deployment. Questions they need to address are #8211; will my legacy applications still work as expected or do I need to reinvest and redeploy everything.
The table below answers some of these questions.
| Usage Scenario | Support Statement |
| Applications built for RS 2005, 2005 SP2 | Will work |
| Applications built for RS 2000 | RS 2000 SOAP APIs are not supported |
| RS 2005 RDL, RS 2000 RDL | URL access will work Can publish Cannot edit |
| RS Database hosted in SQL 2005 | Will work |
| RS Database hosted in SQL 2000 | Not supported |
| VS 2005 ReportViewer Control | Supported |
| SharePoint integration | Supported |
| SharePoint v2 WebParts | Supported |
Similarly when upgrading to SSRS 2008 here are some things to remember
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 server WILL support running legacy RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2005 RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2000 RDL
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 designer has PARTIAL support for legacy RDL
#8211;#160;#160;#160;#160;#160;#160; Converts legacy RDL to 2008 RDL
#8211;#160;#160;#160;#160;#160;#160; If you don#8217;t convert, you cannot open the RDL in the 2008 designer
#8211;#160;#160;#160;#160;#160;#160; CANNOT save to legacy RDL formats
#8226;#160;#160;#160;#160;#160;#160;#160; Published reports upgrade on the fly
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 RDL will NOT work with SQL 2005
#8226;#160;#160;#160;#160;#160;#160;#160; SQL 2005 Report Engine is deprecated
#8211;#160;#160;#160;#160;#160;#160; Snapshots created in 2000 or 2005 WORK in SQL 2008
#8211;#160;#160;#160;#160;#160;#160; They will not work in a version after 2008
Posted by Steve Mann at 3:44 PM | Comments (0)
quot
#160;
by Shruti Sinha, Project Manager
With SQL Server 2008 finally a real option for organizations, IT departments need to address bottom line tactical operational issues before deployment. Questions they need to address are #8211; will my legacy applications still work as expected or do I need to reinvest and redeploy everything.
The table below answers some of these questions.
| Usage Scenario | Support Statement |
| Applications built for RS 2005, 2005 SP2 | Will work |
| Applications built for RS 2000 | RS 2000 SOAP APIs are not supported |
| RS 2005 RDL, RS 2000 RDL | URL access will work Can publish Cannot edit |
| RS Database hosted in SQL 2005 | Will work |
| RS Database hosted in SQL 2000 | Not supported |
| VS 2005 ReportViewer Control | Supported |
| SharePoint integration | Supported |
| SharePoint v2 WebParts | Supported |
Similarly when upgrading to SSRS 2008 here are some things to remember
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 server WILL support running legacy RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2005 RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2000 RDL
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 designer has PARTIAL support for legacy RDL
#8211;#160;#160;#160;#160;#160;#160; Converts legacy RDL to 2008 RDL
#8211;#160;#160;#160;#160;#160;#160; If you don#8217;t convert, you cannot open the RDL in the 2008 designer
#8211;#160;#160;#160;#160;#160;#160; CANNOT save to legacy RDL formats
#8226;#160;#160;#160;#160;#160;#160;#160; Published reports upgrade on the fly
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 RDL will NOT work with SQL 2005
#8226;#160;#160;#160;#160;#160;#160;#160; SQL 2005 Report Engine is deprecated
#8211;#160;#160;#160;#160;#160;#160; Snapshots created in 2000 or 2005 WORK in SQL 2008
#8211;#160;#160;#160;#160;#160;#160; They will not work in a version after 2008
Posted by Steve Mann at 3:44 PM | Comments (0)
Nice to Know Tidbits for SSRS 2008 Deployment and SSRS 2008 Upgrades
#160;
by Shruti Sinha, Project Manager
With SQL Server 2008 finally a real option for organizations, IT departments need to address bottom line tactical operational issues before deployment. Questions they need to address are #8211; will my legacy applications still work as expected or do I need to reinvest and redeploy everything.
The table below answers some of these questions.
| Usage Scenario | Support Statement |
| Applications built for RS 2005, 2005 SP2 | Will work |
| Applications built for RS 2000 | RS 2000 SOAP APIs are not supported |
| RS 2005 RDL, RS 2000 RDL | URL access will work Can publish Cannot edit |
| RS Database hosted in SQL 2005 | Will work |
| RS Database hosted in SQL 2000 | Not supported |
| VS 2005 ReportViewer Control | Supported |
| SharePoint integration | Supported |
| SharePoint v2 WebParts | Supported |
Similarly when upgrading to SSRS 2008 here are some things to remember
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 server WILL support running legacy RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2005 RDL
#8211;#160;#160;#160;#160;#160;#160; RS 2000 RDL
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 designer has PARTIAL support for legacy RDL
#8211;#160;#160;#160;#160;#160;#160; Converts legacy RDL to 2008 RDL
#8211;#160;#160;#160;#160;#160;#160; If you don#8217;t convert, you cannot open the RDL in the 2008 designer
#8211;#160;#160;#160;#160;#160;#160; CANNOT save to legacy RDL formats
#8226;#160;#160;#160;#160;#160;#160;#160; Published reports upgrade on the fly
#8226;#160;#160;#160;#160;#160;#160;#160; RS 2008 RDL will NOT work with SQL 2005
#8226;#160;#160;#160;#160;#160;#160;#160; SQL 2005 Report Engine is deprecated
#8211;#160;#160;#160;#160;#160;#160; Snapshots created in 2000 or 2005 WORK in SQL 2008
#8211;#160;#160;#160;#160;#160;#160; They will not work in a version after 2008
Posted by Steve Mann at 3:44 PM |








