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

Quick Navigation Links: Overview Advantages of using Visual Studio 2010 SP1 or Visual Web Developer Express 2010 SP1 to develop applications for SQL Server Compact 4.0 Visual Studio Designers that do not work with SQL Server Compact...

The SQL Server Compact team is happy to announce that the next version of Microsoft SQL Server Compact 4.0 has been released, and is available for download with the Microsoft Web Platform Installer 3 or from the Microsoft Download Center . SQL Server...

The second community technology preview release of SQL Server Compact 4.0 is available for download from the Microsoft Download Center or as part of the Microsoft WebMatrix Beta 3 in the Microsoft Platform Installer 3.0 . To learn more about Microsoft...

Microsoft SQL Server Compact 4.0 is the next generation of embedded database from the SQL Server family, and brings all of its goodness to the world of ASP.NET web application development. SQL Server Compact 4.0 will provide an easy and simple to use...

For complete instructions about deploying SQL Server Compact ADO.NET Entity Framework provider (System.Data.SqlServerCe.Entity.dll) privately in the application’s folder refer to the blog here . Note that from SQL Server Compact 3.5 SP2 release...

The latest release of SQL Server Compact also referred to as SQL CE or SQL Server Mobile, released with Visual Studio 2010 on the 12th of April 2010. SQL Server Compact 3.5 SP2 is a SQL Server Compact 3.5 with SP2 release, meaning that installing it on...

SQL Server Compact supports predominantly two different sync technologies. “Merge replication” and “Sync Services”. Users might be using one or the other, and interested in knowing the differences between the two technologies, from a use-case point of...

Many times developers get puzzled on which exact set of binaries one should consume in their application. There is also a misconception that SQL CE engine is too big in size. This may be because there was no effort from our side to clarify on “Which binary...

Possible causes for Access Violation exception in general: An access violation occurs in unmanaged or unsafe code when the code attempts to read or write to memory that has not been allocated, or to which it does not have access. This usually occurs...

Some background about SQL Server Compact: SQL Server Compact is an embedded database implemented in native and it can be accessed in application by either OLEDB or ADO.NET provider model. ADO.NET provider for SQL Server Compact is a managed assembly...

If you move a SQLCE database from one platform to other, it's first SqlCeConnection.Open() takes more time and also increases the database file size. The Reason : F or an index on string type columns, SQLCE uses LCMapString API to get the normalized...

Whenever sync is started, developers provide all the necessary properties to an object of SqlCeReplication class. These properties are provided through the constructors or by directly setting the public properties of the object. In this approach developers...

Before going into further details first “ Disclaimer : This is just to help and does not guaranty that this is approved my employer or me J ” Location of SQL Compact Bootstrapper <BootstrapperDir> \Packages\SQL Server Compact Edition\ <LocaleCultureDir>...

There are some optimizations that can be done for an "Sync Services" sync scenario. These are, (might not be an exhaustive list) Small sync chunks (using smaller SyncGroups which are only absolutely necessary) Index creation on tracking and filtering...

Yes, all of them are released on August 11, 2008. SQL Server Compact v3.5 SP1: What is new in this Service Pack? - Click here and here Where to download? SQL Server Compact v3.5 SP1 for Desktops (32-bit and 64-bit) SQL Server Compact...

Database corruptions are often the most painful bugs to repro and debug. A good percentage of the SQL Server Compact bugs reported are in this category. However it so turns out that in majority of the cases Compact is not the culprit. Surprised!! Let...

In Katmai, new datatypes are introduced. Some of these (including some older types in Yukon) are supported for merge replication synching with SQL Compact in SQL Compact 3.5 SP1. These types are mapped to downlevel compatible types for SSC. These types...

Understanding the reason for slowness of a SQL query and then tuning to boost it is a slightly complicated process, but it can be extremely rewarding in some cases. In this post, I am going to list down some ways in which you can tune the query performance...

There were some recent changes that were done in regards to column defaults. In this blog entry I want to bring out, what used to happen and what happens now. I have discussed the case of dropping a default on a column in this post, however, in a case...

Now that SQL Server Compact 3.5 SP1 Beta is released it's time to take the first step, making your first entity application using SQLCE as a backend. In his previous post, Ambrish gave steps on how to install SQL Server Compact SP1 Beta, along with...

The SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3 is available for download at Microsoft Download Center . To install SQL Server Compact 3.5 SP1 Beta Release for ADO.NET Entity Framework Beta 3 Install ADO.NET Entity Framework...

This blog post is meant to give different build version numbers of our SQL Server Compact Releases. This blog post is a living one and gets updated for every release we make. Before getting into the mapping, first you want to know the version you...

Connectivity Cross Version Compatibility This blog post explains the Merge Replication connectivity cross version compatibility scenarios for the SQL Server Compact 3.5 release. For more information about the connectivity cross version compatibility...

So you have run into a problem - how to efficiently report this: System configuration: On a Desktop/Server, Run Winver from Start -> Run. On a Pocket PC, Start -> Settings -> About On a Smart Phone, a bit more steps - start ->...

I know this is very annoying, uninformative, directionless…blah blah… error. And, kindly pardon me for blogging about this error very lately. Better late than never and here it goes. What are the actual errors? 1) Can't find P/Invoke DLL sqlceme30...