Features not supported in SQL Server Compact 4.0

  • Article

Starting with SQL Server Compact 4.0, there are few scenarios and features that are not supported by SQL Server Compact. This topic gives a brief account of features that were supported by the preceding versions of SQL Server Compact, including SQL Server Compact 3.5 SP2.

Features not supported in SQL Server Compact 4.0

SQL Server Compact 3.5 SP2 is the appropriate version for using the following features.

Data replication with SQL Server

SQL Server Compact 4.0 does not support data replication with SQL Server using Sync Framework, merge replication or remote data access (RDA). In order to use this feature, you should use SQL Server Compact 3.5 SP2 version.

SQL Server Integration Services

SQL Server Compact 4.0 does not support SQL Server Integration Services (SSIS). In order us this feature you should use SQL Server Compact 3.5 SP2.

SQL Server Management Studio

Starting from SQL Server Compact 4.0, SQL Server Compact does not support SQL Server Management Studio. The Transact-SQL Editor in the Visual Studio 2010 Service Pack 1 can be used to run T-SQL queries and to view the estimated and the actual query plans for a T-SQL query for the SQL Server Compact database.

LINQ to SQL

SQL Server Compact 4.0 does not support the LINQ to SQL functionality. You can use this feature in SQL Server Compact 3.5 SP2. For more information, see LINQ to SQL (SQL Server Compact).

Note

The ADO.NET Entity Framework 4 that is released with .NET Framework 4 works with SQL Server Compact 4.0. Additional features like support for code-first and server generated keys have been added in SQL Server Compact 4.0 for ADO.NET Entity Framework 4.

Windows Mobile, Windows Phone and Windows CE devices

SQL Server Compact 4.0 does not have a release for Windows Mobile, Windows Phone or for Windows CE devices.

Designers in the VB or C# Windows projects in Visual Studio 2010 SP1

The following wizards do not work with SQL Server Compact 4.0 in the Windows project system. To develop managed applications for SQL Server Compact 4.0, a reference can be manually added to the ADO.NET provider for SQL Server Compact 4.0 (System.Data.SqlServerCe):

  • The Data Source Configuration Wizard that is used to configure datasets.

  • The Configure Data Configuration wizard that is used to setup the syncing of data and schema with SQL Server using Sync FX.

  • The Entity Data Model wizard that is used to generate entities from a Compact database.

For more information about how to use the above features using SQL Server Compact 3.5 SP2, see SQL Server Compact 3.5 SP2 Books Online.