SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop. SQL Server Compact 3.5 SP2 includes a host of new features including: Support for 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 app programming interface (API), namely, System.Data.SqlServerCe.SqlCeChangeTracking. The new Change Tracking API provides ability to configure, enable, and disable change tracking on a table, and to access change tracking data for table; New assembly versioning support and directory structure that enables SQL Server Compact apps that use private deployment to load SQL Server Compact assemblies from within app folder if they’re of higher version than that in the global assembly cache (GAC); Support added for deploying 64-bit version of SQL Server Compact using ClickOnce deployment; Synchronization Services for ADO.NET v1.0 providing ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures.
More Info: Download