BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« 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

Share: del.icio.us Digg Furl ma.gnolia Netscape Newsvine reddit StumbleUpon Yahoo MyWeb  

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

Share: del.icio.us Digg Furl ma.gnolia Netscape Newsvine reddit StumbleUpon Yahoo MyWeb  

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

Share: del.icio.us Digg Furl ma.gnolia Netscape Newsvine reddit StumbleUpon Yahoo MyWeb  

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

Share: del.icio.us Digg Furl ma.gnolia Netscape Newsvine reddit StumbleUpon Yahoo MyWeb  

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

Share: del.icio.us Digg Furl ma.gnolia Netscape Newsvine reddit StumbleUpon Yahoo MyWeb  

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

Share: del.icio.us Digg Furl ma.gnolia Netscape Newsvine reddit StumbleUpon Yahoo MyWeb  

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

Share: del.icio.us Digg Furl ma.gnolia Netscape Newsvine reddit StumbleUpon Yahoo MyWeb  

Posted by Steve Mann at 3:44 PM |