The updates for SQL Server Compact 3.5 SP2 are now referred to a CU (Cumulative Update), which is what the hotfixes also were previously. The difference now is that the CU installation overwrites the existing installation, and a remove of the RTM bits is no longer required before installing the CU. The table below gives an overview of the current CUs. All CUs apply to SQL Compact 3.5 SP2, version 3.5.8080.0.

SQL Server Compact 3.5 (build 3.5.8080.0) has been released to web. SQL Server Compact 3.5 SP2 includes a host of new features including the following: • Support for the Transact-SQL Editor in Visual Studio 2010 that can be used to run free-text T-SQL queries and to view query show-plans for optimizing queries. • Exposes the Change Tracking feature as an application programming interface (API), namely, System.Data.SqlServerCe.SqlCeChangeTracking.

Narkomaniya i toksikomaniya prezentaciya ppt. May 14, 2010  SQL Server Compact 3.5 SP2 Server Tools installs replication components on the computer running the Internet Information Services (IIS) for synchronizing data, using merge replication and remote data access (RDA), between SQL Server Compact 3.5 SP2 database on Windows desktops and mobile devices, and database servers running SQL Server 2005, SQL Server 2008 and SQL Server.

The new Change Tracking API provides the ability to configure, enable, and disable change tracking on a table, and to access the change tracking data for the table. • New assembly versioning support and directory structure that enables the SQL Server Compact applications that use private deployment to load SQL Server Compact assemblies from within the application folder if they are of a higher version than that in the global assembly cache (GAC). • Support added for deploying the 64-bit version of SQL Server Compact using the ClickOnce deployment. • Synchronization Services for ADO.NET v1.0 providing the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. New feature details also available here: - and the product team has more details here: Downloads: Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop Books Online Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Mobile Microsoft SQL Server Compact 3.5 Service Pack 2 Server Tools.