SQL Server IoT 2025 brings long-term stability and AI innovation to edge and embedded devices. Designed for fixed-function, industrial workloads, it combines 10+ years of lifecycle support with advanced security, built-in AI, and high-performance data processing. With seamless connectivity to Azure and Microsoft Fabric, it lets you analyze and act on IoT data directly at the edge while maintaining a unified cloud-to-device architecture.
Binary-equivalent to SQL Server 2025, SQL Server IoT 2025 brings the full power of Microsoft’s modern data engine to OEM and embedded scenarios. It’s trusted for security and performance, now with AI built in, and provides a consistent “ground to cloud to Fabric” experience so you can develop once and deploy across devices, datacenters, and cloud services.
With SQL Server IoT 2025, organizations can securely capture, process, and analyze large volumes of IoT-generated data in real time, unlocking new AI-driven scenarios in manufacturing, retail, healthcare, smart buildings, smart cities, transportation, and more.
The AI-ready enterprise database from ground to cloud
SQL Server IoT 2025 Use Cases
- Security and surveillance: Run AI-powered video analytics and semantic search on live and recorded streams at the edge for faster detection, safer facilities, and reduced bandwidth to the cloud.
- Industrial: Monitor equipment sensors to improve manufacturing efficiency.
- Industrial & manufacturing: Ingest sensor data directly on production lines, use vector search and time-series capabilities to spot anomalies, and improve overall equipment effectiveness (OEE) with low-latency local processing plus cloud analytics when needed.
- Healthcare & medical devices: Support imaging, diagnostics, and connected medical equipment with a secure, reliable database engine that can run AI scenarios while keeping sensitive data close to the point of care.
- Smart cities & infrastructure: Process traffic, environmental, utility, and public-safety telemetry at the edge, mirror key data sets into Fabric for city-wide analytics, and build event-driven applications powered by change event streaming.
- Retail & logistics: Enable shelf monitoring, stock optimization, loss prevention, personalized experiences, and routing optimization using AI-ready data right on store or depot devices.
Benefits of SQL Server IoT 2025 Include
 |
 |
 |
 |
 |
| SQL Server IoT 2025 helps you build intelligent applications using your own data with built-in vector search, embeddings, and natural language capabilities. You can securely connect to AI models in Azure, on premises, or in your local environment using familiar T-SQL, without adding complexity or exposing data to unnecessary risk. | Developers get the most significant SQL Server update in years with native JSON, regular expressions, fuzzy matching, REST endpoint integration, and real time Change Event Streaming. These improvements make it easier to build modern IoT and edge applications and simplify data processing and integration. | SQL Server IoT 2025 continues SQL Server’s leadership in security, now with Microsoft Entra managed identities, TLS 1.3, and improved encryption. Enhanced query execution, optimized locking, and better tempdb governance help maintain uptime and ensure predictable performance for mission critical IoT workloads. | SQL Server IoT 2025 integrates seamlessly with Azure Arc and Microsoft Fabric. You can easily mirror IoT data for near real time analytics without ETL, manage distributed systems through a unified control plane, and scale workloads into Azure when needed. | Run SQL Server IoT 2025 on Windows, Linux, or secure containers. Enhanced Standard and Express editions support a wide range of device classes, from lightweight embedded systems to powerful edge gateways. Partner validated hardware and deployment patterns make it easier to build durable, AI enabled IoT solutions. |
Product highlights for fixed-function and embedded customers.
SQL Server IoT 2025 is a binary equivalent to SQL Server 2025, engineered for fixed-function and embedded devices. It delivers built-in AI, improved performance, broader scalability, and no pricing or licensing changes. Each edition provides a modern, secure, cloud-connected data platform for today’s applications, backed by 10 or more years of support.
Standard
Full featured database with extensive scale for mid-tier applications
- Up to 32 cores of CPU
- Up to 256 GB of memory
- Optimized locking
- Resource Governor
- ZSTD Backup Compression Algorithm
- Basic Availability Groups
- Azure SQL Managed Instance link
- Accelerated Database Recovery
- Backups to S3-compatible object storage
- 524 PB maximum relational databases size
Enterprise
Highest performance and scaling for business-critical workloads
- + Standard features
- Highest core count supported
- Highest memory supported
- Built-in Intelligent Query Processing
- Online and Resumable Index Operations
- Availability Groups: including distributed and contained
- Query Store for readable secondaries
- Persisted Statistics for Secondary Replicas (Query store)
SQL Server IoT 2025 Options
| EOL | EOS | Part # | SQL Server IoT 2025 | COA Typle |
| 3/31/2036 | 1/6/2036 | EP2-59891-1P | SQL Svr Std RUNTIME 2025 IoT ESD OEI 1 Clt Std | J-SERIES/K-SERIES |
| 3/31/2036 | 1/6/2036 | EP2-59892-1P | SQL Svr Std RUNTIME 2025 IoT ESD OEI 5 Clt Std | J-SERIES/K-SERIES |
| 3/31/2036 | 1/6/2036 | EP2-59885-1P | SQL CAL Runtime 2025 IoT ESD OEI 1 Clt Device CAL | J-SERIES/K-SERIES |
| 3/31/2036 | 1/6/2036 | EP2-59886-1P | SQL CAL Runtime 2025 IoT ESD OEI 1 Clt User CAL | J-SERIES/K-SERIES |
| 3/31/2036 | 1/6/2036 | EP2-59887-1P | SQL CAL Runtime 2025 IoT ESD OEI 5 Clt Device CAL | J-SERIES/K-SERIES |
| 3/31/2036 | 1/6/2036 | EP2-59888-1P | SQL CAL Runtime 2025 IoT ESD OEI 5 Clt User CAL | J-SERIES/K-SERIES |
| 3/31/2036 | 1/6/2036 | EP2-59894-1P | SQL Svr Std RUNTIME 2025 IoT ESD OEI 4 Core License | J-SERIES/K-SERIES |
| 3/31/2036 | 1/6/2036 | EP2-59893-1P | SQL Svr Std RUNTIME 2025 IoT ESD OEI 2 Core Addtnl License | J-SERIES/K-SERIES |
| 3/31/2036 | 1/6/2036 | EP2-59890-1P | SQL Svr Ent RUNTIME 2025 IoT ESD OEI 4 Core License | J-SERIES/K-SERIES |
| 3/31/2036 | 1/6/2036 | EP2-59889-1P | SQL Svr Ent RUNTIME 2025 IoT ESD OEI 2 Core Addtnl License | J-SERIES/K-SERIES |
