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...

Author: SQL CE Team Date: 03/15/2011

Microsoft SQL Server Compact 4.0 is available for download

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

Author: SQL CE Team 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...

Author: SQL CE Team Date: 12/22/2010

Introducing SQL Server Compact 4.0, the Next Gen Embedded Database from Microsoft

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

Author: SQL CE Team 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...

Author: SQL CE Team 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...

Author: SQL CE Team Date: 04/14/2010

Merge replication vs. Sync Services for Compact

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

Author: SQL CE Team Date: 11/09/2009

SQL CE Binaries - Details

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

Author: Laxmi Narsimha Rao Oruganti MSFT Date: 10/07/2009

Troubleshooting: Access Violation exception while using SQL Server Compact database with ADO.NET provider

Possible causes for Access Violation exception in general: An access violation occurs in unmanaged...

Author: SQL CE Team Date: 05/05/2009

SQL Server Compact Garbage Collection – Whys and Hows

Some background about SQL Server Compact: SQL Server Compact is an embedded database implemented in...

Author: SQL CE Team Date: 05/05/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...

Author: SQL CE Team Date: 04/01/2009

Overview of SqlCeReplication methods - LoadProperties and SaveProperties

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

Author: SQL CE Team Date: 02/06/2009

How to: Authoring a 64-bit ClickOnce Bootstrapper package in Visual Studio 2008 SP1

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

Author: SQL CE Team Date: 10/06/2008

Sync Services optimizations

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

Author: SQL CE Team Date: 10/06/2008

Disclaimer

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

Author: SQL CE Team 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...

Author: Laxmi Narsimha Rao Oruganti MSFT Date: 08/13/2008

Insight into SQL Server Compact database corruptions

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

Author: SQL CE Team Date: 06/25/2008

Katmai new datatypes support

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

Author: SQL CE Team Date: 06/25/2008

Query performance

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

Author: SQL CE Team Date: 04/30/2008

Dropping Defaults (Column Constraint)

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

Author: SQL CE Team Date: 04/03/2008

My First Entity Application Against SQLCE

Now that SQL Server Compact 3.5 SP1 Beta is released it's time to take the first step, making your...

Author: SQL CE Team Date: 03/07/2008

Download available for SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3

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

Author: SQL CE Team Date: 02/21/2008

SQL Server Compact Release Versions

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

Author: olnrao Date: 02/08/2008

Connectivity Cross Version Compatibility (SQL Server Compact 3.5)

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

Author: olnrao Date: 12/18/2007

"Houston, we got some problem..." and "Houston, we got a problem..." - notice a difference?

So you have run into a problem - how to efficiently report this: System configuration: On a...

Author: SQL CE Team Date: 12/12/2007

Can’t find P/Invoke DLL sqlcemeNN.dll

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

Author: SQL CE Team Date: 10/26/2007

Troubleshooting: Can’t load sqlce dll

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

Author: SQL CE Team Date: 10/26/2007

SqlCeEngine/ISSCEEngine: Shrink Vs Compact

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

Author: SQL CE Team Date: 10/25/2007

SQL Server Compact 3.5 Downloads

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

Author: SQL CE Team Date: 08/30/2007

LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

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

Author: SQL CE Team Date: 08/21/2007

Merge Subscribe Once, Copy and Deploy Multiple Times

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

Author: SQL CE Team Date: 06/26/2007

HOWTO: Pending Changes for a Merge Subscription (Server Side)

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

Author: SQL CE Team Date: 06/26/2007

HTTP/Internet Proxy Detection - Using WINCE API

SqlCeReplication and SqlCeRemoteDataAccess have InternetProxyServer, InternetProxyLogin,...

Author: SQL CE Team Date: 06/19/2007

Connection String - Database Creation-time Only Options

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

Author: SQL CE Team Date: 06/13/2007

The Story of Max Database Size (Connection String Parameter)

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

Author: SQL CE Team Date: 06/13/2007

HOWTO: Pending Changes for a Merge Subscription (Client Side)

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

Author: SQL CE Team Date: 04/18/2007

Merge Replication System Tables

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

Author: SQL CE Team Date: 04/18/2007

SET IDENTITY_INSERT ON/OFF

This command is from SQL Server. This command is to enable the users to set their own value for...

Author: SQL CE Team 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...

Author: SQL CE Team Date: 02/22/2007

Replication and Database Mirroring (Failover) Support

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

Author: SQL CE Team Date: 02/20/2007

Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) RTW

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

Author: SQL CE Team Date: 02/19/2007

HOWTO: Detect the database is Merge Replicated?

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

Author: SQL CE Team Date: 02/19/2007

Annoying error - 28559 - Encountered problems when opening the database

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

Author: SQL CE Team Date: 02/07/2007

SqlCeDataReader.GetSchemaTable - Sample

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

Author: SQL CE Team Date: 02/06/2007

Provider Independent Programming

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

Author: SQL CE Team Date: 01/23/2007

RDA Subscriptions

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

Author: SQL CE Team Date: 01/23/2007

SQL Server 2005 Compact Edition is Released!

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

Author: SQL CE Team Date: 01/18/2007

SQL Server 2005 Mobile Edition - Support for Windows CE 4.2

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

Author: SQL CE Team Date: 01/13/2007

Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) CTP

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

Author: SQL CE Team Date: 01/13/2007

Windows 2000 Support for SQL Server 2005 Compact Edition

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

Author: SQL CE Team Date: 01/13/2007

Next>