SQLTeam.com Logo

Return to SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices (msdn)

SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices (msdn)

Written by Bill Graziano on 15 May 2001

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.