|
Tools |
Features |
Max Size of DB |
Languages Supported |
Connection Protocols |
Footprint |
Operating Systems Supported |
Synchronization/Integration with Backend |
Deployment Options |
Security |
Documentation/Developer Support |
Cost |
SQL Server Compact |
• Microsoft SQL Server Management Studio • Microsoft Visual Studio
|
• Can be deployed on smart devices and computers • SQL Server Compact Edition Tools for Visual Studio 2005 SP1 • SQL Server Compact Edition Developer SDK • SQL Server Compact Edition Server Tools • |DataDirectory| substitution string support
|
4G
|
T-SQL
|
• ADO.NET • ODBC • OLE DB • LINQ
|
• <2MB disk space • 5MB memory
|
• Windows Embedded • Windows Mobile • Windows Desktop • Windows Server
|
• Remote Data Access (RDA) • Merge replication • Requires a Client Access License (CAL) to the host SQL Server
|
• ClickOnce • Microsoft Installer Package (MSI) • Xcopy
|
• Data transfer - 128-bit data encryption • Authentication and authorization for RDA handled by Internet Information Services (IIS) • Encryption via Secure Sockets Layer (SSL) • DB file secured using RSA 128-bit data file encryption and can be password protected
|
• Microsoft Support • Books Online • Blogs • Videos • Community Forums • Newsgroups
|
Free
|
Oracle Database Lite |
• Mobile database offering consists of Database Lite Client and middle tier, Oracle Database Lite Mobile Server • User interface into Mobile Server is Mobile Manager • Mobile Database Workench (MDW) • Mobile Development Kit (MDK) • Packaging Wizard
|
• Synchronization support for SQLite databases • Windows Mobile 5 and 6/CE Standard SDK 5.0 support • Android and Blackberry device support • JDK 1.5 compatibility • C++/.Net stored procedures support • Troubleshooting with Mobile Server Repository Diagnostic Tool (MSRDT) • Oracle RAC support
|
• 4GB of relational data • 16TB of BLOB data
|
• SQL-92 • Java • C++ • .NET stored procedures and triggers
|
• ODBC • JDBC • ADO.NET
|
Starting around 1MB
|
• Windows (2003, XP, Vista) • Windows Mobile (5, 6) • Linux (RedHat) • Linux Embedded • Symbian (7, 8, 9) • Mobile Server is deployable on Windows, Linux, Sun SPARC, HP-UX and IBM AIX
|
• Mobile Server provides bi-directional data synchronization to an enterprise instance of an Oracle database. • Asynchronous and synchronous incremental data synchronization between thousands of mobile users and the Oracle Database recovers from network failures during synchronization • File-based synchronization in absense of network connectivity • Synchronization support has been extended to include SQLite databases with version 10.3 of Database Lite
|
• Packaging Wizard • Mobile Server • Mobile Server integration with the WebLogic Server 11g and Oracle Application Server (OAS)
|
• FIPS-140 compliance • SSL • 128-bit AES encryption
|
• Code samples, and tutorials provided with MDK • Documentation, support and community forums
|
• $60 per user • Mobile Server - $23,000 per processor
|
DB2 Everyplace (Enterprise Edition) |
• Mobile Devices Administration Center • XML Scripting Tool
|
• Optimized for SAP • Transaction support • Failure recovery • Allows for indexing for performance tuning • Stored procedures only supported as remote calls via the Remote Query and Stored Procedure Adapter
|
See DB2 Everyplace limits for a list of DB2 limits
|
• C/C++ • Java • .NET • VB • Subset of standard SQL
|
• DB2 Call Level Interface (CLI) • ODBC • JDBC • ADO.NET
|
350KB
|
• Windows (2000, 2003, XP, Vista, CE) • Linux • Linux Embedded • Symbian • QNX • Palm OS
|
• DB2 Everyplace Sync Server • DB2 Everyplace Sync Client: - secure, bi-directional synchronizing - Runs on Windows (32-bit), Linux (32-bit), Solaris (64-bit), and AIX (64-bit) • servlet is provided for simple, low-volume scenarios
|
WebSphere Application Server Network Deployment
|
• Local data encryption provided by plugins based on individual platforms • DSYEncrypt utility encrypts passwords
|
• SDK, including tutorials and code samples • IBM website - documentaton, support, community forums
|
$166 per user; includes license, software subscription and 12 months of support
|
DB2 Everyplace (Database Edition) |
• Mobile Devices Administration Center • XML Scripting Tool
|
|
See DB2 Everyplace limits for a list of DB2 limits
|
• C/C++ • Java • .NET • VB • Subset of standard SQL
|
|
350KB
|
• Windows (2000, 2003, XP, Vista, CE) • Linux • Linux Embedded • Symbian • QNX • Palm OS
|
Local data storage
|
|
• Local data encryption provided by plugins based on individual platforms • DSYEncrypt utility encrypts passwords
|
• SDK, including tutorials and code samples • IBM website - documentaton, support, community forums
|
$72.50 per user
|
SQL Anywhere |
• Visual Studio • Eclipse • PowerBuilder
|
• 20,000 transactions per minute • Veritas Cluster Server (VCS) agent • UltraLiteJ for use on BlackBerry devices and with J2SE • v.12: Support for spatial data, language extensions, performance improvements, support for iPhone, and more
|
Hundreds of GB of data
|
• C# • VB.NET • C/C++ • ASP • XML • Java • Special drivers for PERL and PHP
|
• ODBC • JDBC • ADO.NET • OLE DB • Open Client
|
• 10MB hard disk • 4MB of memory • UltraLite version: 75KB
|
• Windows • Windows Mobile • Linux • Linux Embedded • Mac OSX on Intel • Sun SolarisIBM AIX • HP-UX • MobiLink: Windows, Linux, Mac OS X, Sun Solaris, IBM AIX, HP-UX
|
Bi-directional replication is accomplished using MobiLink
|
Deployment Wizard
|
Optional purchases: RSA and ECC encryption protocols
|
• Documentation • Community forums • Webcasts
|
Dependent on what you need to do with it, who will be using it, how many will be using it, and what platform you are targeting
|
SQL Lite |
• TCL (Tool Command Language) • C/C++ interface to SQLite • Management Tools • Converter Tools • SQLite Wrappers • SQLite Reporting
|
• Zero-Configuration • Serverless • Single Database File • Stable Cross-Platform Database file
|
1 terabyte
|
SQL-92
|
N/A
|
<275K
|
Cross-platform, 32-bit and 64-bit systems
|
N/A
|
|
Support for reading and writing encrypted databases using these algorithms: RC4, AES-128 in OFB mode, AES-128 in CCM mode, and AES-256 in OFB mode
|
• Documentation • Wiki • Sample code • Upgrade guidance • API references
|
Public domain
|