We don't need to install complete SQL SERVER Engine to build reports SSRS tool, Management tools and other advance features as we do in previous versions.
More detail can be viewed from this link
http://shamas-saeed.blogspot.com/2012/05/sql-server-2008-express-with-advance.html
I got this detail from different sources of msdn linked below.You can download it from this link
http://www.microsoft.com/en-us/download/details.aspx?id=1842
features supported and unsupported by SSRS 2008 Express with Advance Edition is
SQL Server Express provides the following Reporting Services functionality:
· On-demand report processing for each user who views a report. When a user opens a report, the report is initialized, the query is processed, data is merged into the report layout, and the report is rendered into a presentation format.
· Rendering formats are available for HTML, Acrobat, and Excel.
· Report data sources must be SQL Server relational databases that run locally in SQL Server Express.
· Report server management and report viewing are supported through Report Manager.
· Configuration is supported through the Reporting Services Configuration tool.
· Rs.exe, rsconfig.exe, and rskeymgmt.exe command line utilities are available in SQL Server Express.
· Windows Authentication and predefined roles are used to map existing group and user accounts to a named collection of operations.
Other editions of SQL Server include a larger set of Reporting Services features. The following list describes the features that are documented in SQL Server Books Online, but cannot be used in this edition:
· Scheduled report processing, caching, snapshots, subscriptions, and delivery are not supported.
· Analysis Services, Oracle, XML, SAP, SQL Server Integration Services (SSIS), OLE DB, and ODBC data sources are not supported.
· Remote data sources are not supported. Reports that are hosted in a SQL Server Express report server must retrieve SQL Server relational data from a local SQL Server Express Database Engine instance.
· Ad hoc reporting through semantic models and Report Builder is not supported.
· TIFF (Image), XML, and CSV rendering extensions are not supported.
· The Reporting Services API extensible platform for delivery, data processing, rendering, and security is not supported.
· Custom authentication extensions and custom role assignments are not supported. You must map existing Windows domain user and group accounts to predefined role definitions.
· Custom report items are not supported.
· Managing a long-running report process is not supported. Specifically, you cannot use the Manage Jobs feature in Report Manager to stop report processing.
· Scale-out deployment is not supported.
· SharePoint integrated mode is not supported.
· Report Builder 2.0 is not supported. Report Builder 2.0 can connect to a SQL Server Express database on the local computer or on a remote report server.
list of Supported features and not Supported features in SQL SERVER Express 2008
http://msdn.microsoft.com/en-us/library/ms365248(v=sql.100).aspx
SQL Server Express supports most of the features and functionality of SQL Server 2008. This includes the following:
Stored procedures
|
SQL Server Configuration Manager
|
Views
|
Replication (as a subscriber only)
|
Triggers
|
Advanced Query Optimizer
|
Cursors
|
SMO/RMO
|
sqlcmd and osql utilities
|
Integration with Visual Studio
|
Snapshot isolation Levels
|
Service Broker (as a client only)¹
|
Native XML support. This includes XQuery and XML schemas
|
SQL CLR
|
Transact-SQL language support
|
Multiple Active Result Sets (MARS)
|
Dedicated Administrator Connection²
|
Full text search
|
Subset of Reporting Services features³
|
Import/Export Wizard
|
The following table lists the additional SQL Server 2008 database features that are not supported in this version of SQL Server Express. It also lists database features from earlier versions of SQL Server that are not supported.
|
SQL Server features
not supported in SQL Server Express
|
SQL Server
features from earlier versions not supported in SQL Server Express
|
|
Database mirroring
|
SQL Mail
|
|
Online restore
|
Failover clustering
|
|
Database snapshot
|
Distributed partitioned views
|
|
Parallel index operations
|
VIA protocol support
|
|
Mirrored media sets
|
Log shipping
|
|
Partitioning
|
Parallel DBCC
|
|
Address Windowing Extensions (AWE)
|
Parallel Create Index
|
|
Hot-add memory
|
Enhanced Read Ahead and Scan
|
|
Native HTTP SOAP access
|
Indexed views (materialized views)
|
|
SQL Mail and Database Mail
|
Partitioned views
|
|
Online Index Operations
|
-
|
|
SQL Server Agent and SQL Server Agent Service
|
-
|
No comments:
Post a Comment