Mobile Development Platform Comparison Matrix : Page 2

• 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

• 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

• 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

• 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

• 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

• 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