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


Comments (15)

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

  2. Ian Thomas says:

    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?

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

  4. upto says:

    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/

  5. Steve Lasker says:

    Ian,

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

    Steve

  6. Nino.Mobile says:

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

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

  8. Bob Li says:

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

  9. Eugene Loch says:

    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!

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

  11. Steve Lasker says:

    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.  

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

  13. db-dude says:

    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?

  14. Steve Lasker says:

    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

  15. markovich says:

    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.  

Skip to main content