Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition

Download UpgradingSQLServerCE.doc 201 KB Microsoft Word file Get Office File Viewers

SQL Server 2005 Compact Edition represents the next evolutionary step of the powerful, lightweight relational database for Windows Mobile applications. Its predecessors, SQL Server Mobile Edition and SQL Server CE 2.0, functioned as both on-device persistent data repositories and offline data caches for mobile architectures that involve synchronizing data by using merge replication or remote data access (RDA) with larger SQL Server 2000 or SQL Server 2005 databases.

Because databases created with SQL Server Mobile Edition work seamlessly with SQL Server Compact Edition, this paper focuses on upgrading SQL Server CE to SQL Server Compact Edition. You can upgrade your physical SQL Server CE 2.0 database and data synchronization architecture to SQL Server 2005 Compact Edition. In addition, new features are available in SQL Server 2005 Compact Edition that represent an upgrade to SQL Server CE 2.0 in terms of achieving on-going database health and maintenance. This article first introduces the topic of running SQL Server CE 2.0 and SQL Server 2005 Compact Edition in a side-by-side coexistence model.

Included in this document:

Top of page