The Curious Engineer

All blogs / Databases

Microsoft's Embedded Database

learn.microsoft.com/en-us/archive/blogs/sqlservercompact

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.

DatabasesEmbedded / microcontrollersMicrosoft blogsMSDN archive

’10’15’20’25
Posts
47 from 13 Jan 2007 to 15 Mar 2011
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlservercompact/feed.xml

2011 2

  1. SQL Server Compact 4.0 Tooling Support in Visual Studio 2010 SP1 and Visual Web Developer Express 2010 SP1
  2. Microsoft SQL Server Compact 4.0 is available for download

2010 4

  1. 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.
  2. Introducing SQL Server Compact 4.0, the Next Gen Embedded Database from Microsoft
  3. 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
  4. Microsoft SQL Server Compact 3.5 with Service Pack 2 released with Visual Studio 2010 and on the Web.

2009 4

  1. Merge replication vs. Sync Services for Compact
  2. SQL CE Binaries - Details
  3. After moving the database from one platform to other, the first SqlCeConnection.Open() takes more time
  4. Overview of SqlCeReplication methods - LoadProperties and SaveProperties

2008 10

  1. How to: Authoring a 64-bit ClickOnce Bootstrapper package in Visual Studio 2008 SP1
  2. Sync Services optimizations
  3. Disclaimer
  4. Released - SQL Server Compact v3.5 SP1, SQL Server 2008 RTM, Visual Studio 2008 SP1, .NET Framework v3.5 SP1
  5. Insight into SQL Server Compact database corruptions
  6. Katmai new datatypes support
  7. Query performance
  8. Dropping Defaults (Column Constraint)
  9. Download available for SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3
  10. SQL Server Compact Release Versions

2007 27

  1. Connectivity Cross Version Compatibility (SQL Server Compact 3.5)
  2. Can’t find P/Invoke DLL sqlcemeNN.dll
  3. Troubleshooting: Can’t load sqlce dll
  4. SqlCeEngine/ISSCEEngine: Shrink Vs Compact
  5. SQL Server Compact 3.5 Downloads
  6. LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)
  7. Merge Subscribe Once, Copy and Deploy Multiple Times
  8. HOWTO: Pending Changes for a Merge Subscription (Server Side)
  9. HTTP/Internet Proxy Detection - Using WINCE API
  10. Connection String - Database Creation-time Only Options
  11. The Story of Max Database Size (Connection String Parameter)
  12. HOWTO: Pending Changes for a Merge Subscription (Client Side)
  13. Merge Replication System Tables
  14. SET IDENTITY_INSERT <Table Name> ON/OFF
  15. ADS - Automatically Starting the synchronization between device and desktop
  16. Replication and Database Mirroring (Failover) Support
  17. Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) RTW
  18. HOWTO: Detect the database is Merge Replicated?
  19. Annoying error - 28559 - Encountered problems when opening the database
  20. SqlCeDataReader.GetSchemaTable - Sample
  21. Provider Independent Programming
  22. RDA Subscriptions
  23. SQL Server 2005 Compact Edition is Released!
  24. SQL Server 2005 Mobile Edition - Support for Windows CE 4.2
  25. Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) CTP
  26. Windows 2000 Support for SQL Server 2005 Compact Edition
  27. Sync With Access