Search Windows Embedded Sites
Home » Discover » Products » Microsoft SQL Server

Microsoft SQL Server for Embedded Systems

Microsoft SQL Server for embedded systems is binary identical to Microsoft SQL Server, intended for use in an embedded solution consisting of purpose-built hardware running the Windows Embedded Server Operating System and application software. Microsoft SQL Server 2008 R2 for embedded systems builds on the strong foundation and proven capabilities of Microsoft SQL Server 2008 for embedded systems, providing OEMs with a robust database for their embedded applications deployed on server appliances.
Microsoft SQL Server for embedded systems family includes:
  • Microsoft SQL Server 2008 R2 for embedded systems
  • Microsoft SQL Server 2008 for embedded systems
  • Microsoft SQL Server 2005 for embedded systems
  • Microsoft SQL Server 2000 for embedded systems

Features at a glance:

Microsoft SQL Server 2008 R2 for embedded systems FeatureWorkgroupStandardEnterprise
Max supported processors248
Max supported RAM4GB64GB2TB
Virtual Machines114
StreamInsightNoYesYes
Failover ClusteringNo2-node16-node
Database MirroringNo (witness only)YesYes
Cost Contact a Windows Embedded Authorized Distributor for detailsContact a Windows Embedded Authorized Distributor for detailsContact a Windows Embedded Authorized Distributor for details
Support10-year product support lifecycle**10-year product support lifecycle**10-year product support lifecycle**
Availability15 years15 years15 years
** 10 year product support is a combination of 5 years mainstream support and 5 years extended support. See Microsoft.com for more details

Microsoft SQL Server 2008 R2 for embedded systems Advantages


For OEMs wanting to offer cutting edge server appliances, Microsoft SQL Server 2008 R2 for embedded systems, which builds on the strong foundation and proven capabilities of Microsoft SQL Server 2008 for embedded systems, provides OEMs with a robust database for their embedded applications deployed on server appliances and offers rich capability to support Business Intelligence workloads out of the box at a low total cost of ownership

High Availability

Microsoft SQL Server 2008 R2 for embedded systems ensures data protection and data availability through fast recovery and reliable redundancy using technologies such as failover clustering and database mirroring

Built-in Security features and compliance capabilities

Microsoft SQL Server 2008 R2 for embedded systems’ built-in security features and compliance capabilities help provide effective management of security feature configuration, strong authentication and access control, powerful encryption and enhanced auditing for your server appliances

Virtualization

Extend your server appliances to increase hardware utilization and ensure workload isolation through virtualization. Using Hyper-V®, OEMs can host multiple virtual machines on the same server appliance while maintaining full isolation at the operating system level. This enables you to manage the performance, security, manageability, and business continuity of each virtual machine independently. It also gives you the flexibility to run multiple operating systems on the same hardware where required for specific server appliances. Because of the deep level of interoperability of Windows Server 2008 R2 for embedded systems with SQL Server 2008 R2 for embedded systems, your server appliances will be able to take advantage of the full range of functionality that Hyper-V virtualization offers.

Business Intelligence

OEMs need to empower end user to utilize familiar tools to integrate the data from server appliances into the applications used in the enterprise. Microsoft SQL Server 2008 R2 for embedded systems Analysis Services provides optimized Office interoperability, as OEMs can integrate the data from their server appliances into the end user decision process, with Microsoft® PowerPivot for Microsoft® Excel 2010.
OEMs can leverage Microsoft SQL Server for embedded systems in a wide variety of server appliances, including:
  • Telco server appliances in the network management and business applications stacks, that may run databases to collect and monitor the Telco infrastructure
  • Medical imaging server appliances that may run data bases for Picture Archiving and Communications Systems (PACS)
  • Industrial Automation server appliances that might query data coming from sensors on an assembly line to calculate performance metrics and spot production problems
  • Video Management Systems server appliances in the Security & Surveillance industry
  • In-store server appliances to consolidate Kiosks and digital signage devices data, which may utilize the SQL Server database, that transmit the data to a datacenter for data visualization, and customer loyalty applications, customer buying habits research, and more

New to Microsoft SQL Server for embedded systems

Now Available for Review in Beta: the Next Generation of SQL Server

Case Studies:
Real World Examples