United States Change | All Microsoft Sites
Microsoft Home | Servers and Tools
Get the latest version of SQL Server Compact 3.5 Service Pack 1 and start building a new generation of embedded database applications for desktops and mobile devices. SQL Server Compact 3.5 Service Pack 1 includes a host of new features and enhancements to the existing features that let developers rapidly develop and deploy applications using SQL Server 2008 and Visual Studio 2008 Service Pack 1. The new features and enhancements include the following:
Support for ADO.NET Entity Framework
Case-sensitive collations at the database level
Runs natively in the 64-bit environment
Improved support for private deployment of 32-bit and 64-bit applications
Replication of the new data types in SQL Server 2008 such as Date, Time, DateTime2, DateTimeOffset, Geography, and Geometry to SQL Server Compact. The new data types in SQL Server 2008 are supported through mapped data types such as nchar, nvarchar, image, etc. in SQL Server Compact
Enhanced version compatibility between SQL Server Compact and SQL Server 2008 for merge replication, including support for SQL Server 2005 publications
Support for Synchronization Services for ADO.NET version 1.0 Service Pack 1 that include the following new features:
Synchronization of data between SQL Server Compact 3.5 on mobile devices or desktop with SQL Server and any other ADO.NET Data Provider
Support for SQL Server 2008 change tracking
Replication of the new data types in SQL Server 2008
Tracing of the synchronization process to easily troubleshoot issues
Small 1.8 MB free redistributable runtime database engine for developing and running applications on Windows desktop operating systems.
Extend enterprise applications to mobile devices by rapidly building and deploying SQL Server Compact 3.5 Service Pack 1 based application with Visual Studio 2008 Service Pack 1.
Replicate data between SQL Server Compact 3.5 Service Pack 1 and SQL Server 2008 by using merge replication and remote data access (RDA).
Learn about new features, work through how-to applications and samples and get up to speed easily with SQL Server Compact 3.5 Service Pack 1.
Provides the ability to synchronize data on mobile devices to SQL Server from disparate sources over two-tier, N-tier, and service-based architectures.
Learn more about the new data replication technology and start developing intelligent occasionally connected applications.
Get SQL Server Compact 3.5 and start building embedded database applications for desktops and mobile devices. SQL Server Compact 3.5 features include LINQ to SQL support, Microsoft Synchronization Services for ADO.NET, plus enhanced support for T SQL statements that lets developers rapidly develop and deploy applications using Visual Studio 2008.
Extend enterprise applications to mobile devices by rapidly building and deploying SQL Server Compact 3.5 based application with Visual Studio 2008.
Replicate data between SQL Server Compact 3.5 and SQL Server 2005 by using merge replication and remote data access (RDA).
Learn about new features, work through how-to applications and samples and get up to speed easily with SQL Server Compact 3.5.
Microsoft SQL Server Compact Edition is the compact database for rapidly developing applications in both native and managed environment that extend enterprise data management capabilities to desktop applications
SQL Server Compact Edition Developer SDK contains the files required for installing SQL Server Compact Edition on mobile devices, desktop and tablet PC. It also has the Help File, and the Header files for native development, and the Northwind sample application.
Microsoft SQL Server Compact Edition Server Tools updates the servers running IIS to support connectivity solutions from SQL Server 2005 Compact Edition database on a mobile device or a desktop or a tablet PC to database servers running SQL Server 2000 SP3a and above versions
Download SQL Server Compact Edition (SSCE) Books Online and Readme.
The download is installed after the installation of Visual Studio 2005 SP1 and updates the Smart Device Development components in Visual Studio 2005 SP1 with the SQL Server Compact Edition design time UI/Dialogs, device CAB files, and includes new features like Click Once support.
