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.
SQL Server Compact 4.0 Tooling Support in Visual Studio 2010 SP1 and Visual Web Developer Express 2010 SP1
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
Downloads Available for SQL Server Compact 4.0 CTP2, Visual Studio 2010 SP1 Beta Tools for SQL Server Compact 4.0 CTP2, and CMS (mojoPortal, Orchard and Umbraco) that work with SQL Server Compact.
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
Troubleshooting: Privately deploying the SQL Server Compact 3.5 SP2 ADO.NET Entity Framework provider (System.Data.SqlServerCe.Entity.dll) in the application folder does not work
For complete instructions about deploying SQL Server Compact ADO.NET Entity Framework provider...
Date: 05/12/2010
Microsoft SQL Server Compact 3.5 with Service Pack 2 released with Visual Studio 2010 and on the Web.
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
After moving the database from one platform to other, the first SqlCeConnection.Open() takes more time
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
Released - SQL Server Compact v3.5 SP1, SQL Server 2008 RTM, Visual Studio 2008 SP1, .NET Framework v3.5 SP1
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
SET IDENTITY_INSERT ON/OFFThis command is from SQL Server. This command is to enable the users to set their own value for...
Date: 04/13/2007
ADS - Automatically Starting the synchronization between device and desktop
Hi, I have received many question on how to automatically start synchronization between the device...
Date: 02/22/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