Partager via

Comparing SQL Server Express and Compact Editions Whitepaper

  • Article

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.
https://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc

Steve

Comments

  • Anonymous
    November 07, 2006
    Steve Lasker has posted a great whitepaper that describes the differences between SQL/e and SSCE. ...

  • Anonymous
    November 07, 2006
    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?

  • Anonymous
    November 08, 2006
    New and Notable 120 [Via: SamGentile ] Top Five Developer API's [Via: Scott Watermasysk ] ClickOnce...

  • Anonymous
    November 09, 2006
    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/

  • Anonymous
    November 13, 2006
    Ian, Yes, SQLce can be freely distributed with your app without any SQL Server licenses.   Steve

  • Anonymous
    November 14, 2006
    Software / Hardware The FCC has approved the Treo 750 for use in the US . This means we'll being seeing

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

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

  • Anonymous
    March 15, 2007
    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!

  • Anonymous
    March 18, 2007
    Not surprisingly we've been get a lot of great questions about specific features and scenarios for our

  • Anonymous
    March 18, 2007
    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.  

  • Anonymous
    March 22, 2007
    Q: Can I use Merge and Sync Services together? A: As we've all seen with our SQLce and Express discussions

  • Anonymous
    June 11, 2007
    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?

  • Anonymous
    June 19, 2007
    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

  • Anonymous
    October 06, 2007
    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.