SQL Server CE
SQL Server for Windows CE is a mobile version (operating in 13MB of memory) of Microsoft's enterprise SQL Server database. SQL Server CE supports a host of advanced capabilities, including complete support for SQL Server SQL grammar, a wide variety of SQL Server datatypes, nested transactions, 128-bit encryption, and merge replication with SQL Server 2000. Data can be accessed via the ADOCE or OLE DB/CE APIs (discussed in the next section). Compared to Pocket Access or the WinCE data store, massive performance improvement is obtained through direct index seeking via ADOCE. The SQL Server CE database engine occupies between 800KB and 1.3MB of memory, and databases of up to 2GB (!) are supported.