Welcome to MSDN Blogs Sign in | Join | Help

Comparing SQL Server Express and Compact Editions Whitepaper

We just published a whitepaper comparing Express and Compact Edition.  The reality is the paper tends to focus less on a direct comparison of the products, but rather an evaluation of what’s needed in a local data store.  Express edition is our Data Service entry point from single user to multi-user scenarios.  With the release of Compact Edition, we are positioning Compact Edition as the default local database and will focus local data feature in Compact Edition, and low end Data Service scenarios around Express.  This point is that one size doesn’t fit all, but two definitely conquer a tremendous amount of territory.
http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc

Steve

Published Wednesday, November 08, 2006 6:17 AM by Steve.Lasker

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Comparing SQL Server Express with SQL Server Compact Edition

Wednesday, November 08, 2006 3:39 AM by Nick Randolph's .NET Travels

Steve Lasker has posted a great whitepaper that describes the differences between SQL/e and SSCE. ...

# re: Comparing SQL Server Express and Compact Editions Whitepaper

Wednesday, November 08, 2006 4:46 AM by Ian Thomas

What' the current / future licensing for SQL Server CE v3.1 - ie, can it be freely distributed and used on the desktop, by non-developers, and without any other form of SQL Server license?

# Link Listing - November 8, 2006

Wednesday, November 08, 2006 10:59 PM by Christopher Steen

New and Notable 120 [Via: SamGentile ] Top Five Developer API's [Via: Scott Watermasysk ] ClickOnce...

# re: Comparing SQL Server Express and Compact Editions Whitepaper

Thursday, November 09, 2006 11:09 PM by upto

good material for making decision between SSCE and SQL/e. thanks very much!

i have written some posts about SSCE in Chinese :)

http://upto.cnblogs.com/

# re: Comparing SQL Server Express and Compact Editions Whitepaper

Monday, November 13, 2006 6:58 PM by Steve.Lasker

Ian,

Yes, SQLce can be freely distributed with your app without any SQL Server licenses.  

Steve

# The Mobile Minute 152

Tuesday, November 14, 2006 9:32 AM by Nino.Mobile

Software / Hardware The FCC has approved the Treo 750 for use in the US . This means we'll being seeing

# SQL Server Compact Edition under ASP.net and IIS

Monday, November 27, 2006 1:07 PM by Steve Lasker's Web Log

We routinely get requests, complaints, or sometimes even threats, (If you don’t enable it, I’ll use product

# 在SQL Server Express版和Compact版之间做出选择

Tuesday, February 06, 2007 1:13 AM by Bob Li

SQL Server Compact 版开发组刚刚发布了一份比较 Express 版和 Compact 版的白皮书，指导开发人员如何在如何在它们之间做一个正确的选择。

# re: Comparing SQL Server Express and Compact Editions Whitepaper

Thursday, March 15, 2007 5:59 PM by Eugene Loch

In my 20+ years of developing software and hence dealing with MS technologies, this is the *only* document from Microsoft *ever* that explains the issues in a clear, unambiguous manner.  Most importantly, it gave me the information I needed!  Bravo!

# Q&A on OCS & Sync Services for ADO.NET

Sunday, March 18, 2007 11:07 AM by Steve Lasker's Web Log

Not surprisingly we've been get a lot of great questions about specific features and scenarios for our

# re: Comparing SQL Server Express and Compact Editions Whitepaper

Sunday, March 18, 2007 11:25 AM by Steve.Lasker

Thanks Eugene,

At the time the style and even some of the content was very controversial, so it took a lot of work and support to get it published.  Mike Wachal, Dhilip Gopalakrishnan, Anil Nori and Dan Winn all contributed to the final content and helped get it published.  

# Combining Merge and Sync Services

Thursday, March 22, 2007 12:55 PM by Sync Services FAQ

Q: Can I use Merge and Sync Services together? A: As we've all seen with our SQLce and Express discussions

# re: Comparing SQL Server Express and Compact Editions Whitepaper

Monday, June 11, 2007 5:44 PM by db-dude

I heard SQL CE is a free software by itself.

Does it require a CAL on a SQL Server Standard/Workgroup edition if it is connected to them?

# re: Comparing SQL Server Express and Compact Editions Whitepaper

Tuesday, June 19, 2007 11:52 PM by Steve.Lasker

Hi db-dude,

Yes, SQLce is free.  And yes, connecting to SQL Server Standard, Workgroup or Enterprise does require a CAL, regardless of whether you connect via Sync Services, Merge, RDA, or simply use the SqlConnection.  Sort of what you're asking is does using the free version of SQLce give you a free connection to SQL Server <g>.  

Steve

# re: Comparing SQL Server Express and Compact Editions Whitepaper

Saturday, October 06, 2007 4:18 PM by markovich

At the time the style and even some of the content was very controversial, so it took a lot of work and support to get it published.  Mike Wachal, Dhilip Gopalakrishnan, Anil Nori and Dan Winn all contributed to the final content and helped get it published.  

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker