Microsoft's Embedded Database - SQL Server Compact - Team Blog

SQL Server Compact is a SKU of SQL Server family of products from Microsoft. This is a thin light-weight, embedded, in-proc database engine which supports synchronization to SQL Server, etc.

Quick Navigation Links: Overview Advantages of using Visual Studio 2010 SP1 or Visual Web Developer...

Date: 03/15/2011

The SQL Server Compact team is happy to announce that the next version of Microsoft SQL Server...

Date: 01/12/2011

The second community technology preview release of SQL Server Compact 4.0 is available for download...

Date: 12/22/2010

Microsoft SQL Server Compact 4.0 is the next generation of embedded database from the SQL Server...

Date: 07/07/2010

For complete instructions about deploying SQL Server Compact ADO.NET Entity Framework provider...

Date: 05/12/2010

The latest release of SQL Server Compact also referred to as SQL CE or SQL Server Mobile, released...

Date: 04/14/2010

SQL Server Compact supports predominantly two different sync technologies. “Merge replication” and...

Date: 11/09/2009

Many times developers get puzzled on which exact set of binaries one should consume in their...

Date: 10/07/2009

If you move a SQLCE database from one platform to other, it's first SqlCeConnection.Open() takes...

Date: 04/01/2009

Whenever sync is started, developers provide all the necessary properties to an object of...

Date: 02/06/2009

Before going into further details first “Disclaimer: This is just to help and does not guaranty that...

Date: 10/06/2008

There are some optimizations that can be done for an "Sync Services" sync scenario. These are,...

Date: 10/06/2008

Disclaimer: The information in this weblog is provided "AS IS" with no warranties, and confers no...

Date: 10/06/2008

Yes, all of them are released on August 11, 2008. SQL Server Compact v3.5 SP1: What is new in this...

Date: 08/13/2008

Database corruptions are often the most painful bugs to repro and debug. A good percentage of the...

Date: 06/25/2008

In Katmai, new datatypes are introduced. Some of these (including some older types in Yukon) are...

Date: 06/25/2008

Understanding the reason for slowness of a SQL query and then tuning to boost it is a slightly...

Date: 04/30/2008

There were some recent changes that were done in regards to column defaults. In this blog entry I...

Date: 04/03/2008

The SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3 is available for download at...

Date: 02/21/2008

This blog post is meant to give different build version numbers of our SQL Server Compact Releases....

Date: 02/08/2008

Connectivity Cross Version Compatibility This blog post explains the Merge Replication connectivity...

Date: 12/18/2007

I know this is very annoying, uninformative, directionless…blah blah… error. And, kindly pardon me...

Date: 10/26/2007

SQL Server CE/Comapct uses Windows API LoadLibrary (PlatformBuilder or WinCE or Win32) to load the...

Date: 10/26/2007

The difference between these two is much similar to Internal and External Memory Fragmentation. From...

Date: 10/25/2007

Microsoft SQL Server Compact 3.5 released with Visual Studio 2008. The English release of SQL Server...

Date: 08/30/2007

Querying data from Sql Server Compact database gets easier! “LINQ” stands for .net Language...

Date: 08/21/2007

"Merge Subscribe Once, Copy and Deploy Multiple Times" - This has been the real good feature I like...

Date: 06/26/2007

Earlier in the other blog article we discussed on “HOWTO: Pending Changes for a Merge Subscription...

Date: 06/26/2007

SqlCeReplication and SqlCeRemoteDataAccess have InternetProxyServer, InternetProxyLogin,...

Date: 06/19/2007

In this article, we will discuss the Connection String Parameters that are meant for use only for...

Date: 06/13/2007

Maximum Database Size is NOT a persistent configuration (It is NOT stored in database file). SQL CE...

Date: 06/13/2007

Often there will be need to find out if there are any pending changes on client side to upload. Note...

Date: 04/18/2007

The earlier blog post “How to: Detect the database is merge replicated”, gave a list of the system...

Date: 04/18/2007

Replication and Database Mirroring (Failover) support for Merge Replication between SQL Server 2005...

Date: 02/20/2007

Hi, Today we are very pleased to announce the RTW release of Microsoft SQL Server 2005 Compact...

Date: 02/19/2007

Sometimes an application may want to know whether the database is in good shape in terms of Merge...

Date: 02/19/2007

We have been hearing lot of complaints on how to get more information for error 28559 when doing RDA...

Date: 02/07/2007

I have written a cute sample to show how different fields change with different constraints and...

Date: 02/06/2007

Have you heard of Provider Agnostic Programming aka Base Class Provider Model aka Provider...

Date: 01/23/2007

Q1. How do I know whether the RDA Pulled table is tracked or not? OR What an RDA Subscribed table...

Date: 01/23/2007

SQL Server 2005 Compact Edition (version 3.1) or SSCE 3.1 is released to the web. SQL Server 2005...

Date: 01/18/2007

SQL Server 2005 Mobile Edition is now available for Windows CE 4.2 for following processors: ARMv4,...

Date: 01/13/2007

Today we are very pleased to announce the CTP release of Microsoft SQL Server 2005 Compact Edition...

Date: 01/13/2007

Hi, We have been getting good feedback from you all on the CTP release of SQL Server 2005 Compact...

Date: 01/13/2007

Next>