none
Is SQL Server Compact Dead ?

    Question

  • Hi have a new project that needs a small footprint,t not networked, database for storage and retrieval  during desktop program operation (no data needs to be stored after program is closed). This is multithreading program that retrieves web pages asynchronously puts retrieved data into a temp database and will need to display whatever it has at the moment (even if some requests are not processed yet) in a grid with SQL filtering.  Also the PCs that this will run on will be old and I do not want to install a database server on each one...

    So the question is should I use SQL compact or is it currently used by those that already had it in a project ? and no new projects should look at it ?

    Thanks

    Will access from desktop C# winforms program,  using 3.5 maybe 4.x framework.

    Monday, November 11, 2013 5:36 PM

Answers

  • I also started to worry about this product and everything I have found on the net so far points to SQL Server CE being deprecated. There has been nothing officially announced by Microsoft with the closest being a response to a MS Connect issue:

    "SQL Server compact edition is in deprecation mode with no new releases planned near future. Last release SQL CE 4.0SP1 (and earlier releases that are still in the support cycle) will continue to be supported through its lifecycle and Microsoft is committed to fix any major, production blocking issues found in these releases." (Microsoft Connect)

    The mainstream support for CE 4.0 will end on 2016-07-12 and extended support 2021-07-13 unless they release a new service pack, which I see as doubtful (Microsoft Support).

    Support for SSCE has also not been included in Visual Studio 2013 and SQL Server 2014 Management Studio.  Erik's SQL Server Compact Toolbox can be used to add support back to VS2013 (CodePlex).  SQL Server CE has even now been removed from the SQL Server website.  It still shows up in search results from Microsoft search (Micorsoft) but sometime back in March or April the page was removed (Wayback Machine).

    There are a couple of UserVoice suggestions asking for Microsoft to support and develop SQL Server CE further:

    Support Sql Server Compact in VS2013

    Sql server Compact 5

    So overall even though nothing has been announced it seems pretty clear to me that Microsoft are not continuing development of SQL Server CE and do not want people to use it.  It's dead!

    Friday, June 27, 2014 2:21 AM
  • SQL Server Compact should be able to fullfill your requirements.

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    Monday, November 11, 2013 7:50 PM
    Moderator

All replies

  • SQL Server Compact should be able to fullfill your requirements.

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    Monday, November 11, 2013 7:50 PM
    Moderator
  • Do you have any news about a roadmap for SQL Server Compact?

    With the lack of native support in VS 2013 and Windows Phone for SQL Server Compact 4.0, I start to worry about the future of this product.

    Saturday, November 16, 2013 12:08 AM
  • I also started to worry about this product and everything I have found on the net so far points to SQL Server CE being deprecated. There has been nothing officially announced by Microsoft with the closest being a response to a MS Connect issue:

    "SQL Server compact edition is in deprecation mode with no new releases planned near future. Last release SQL CE 4.0SP1 (and earlier releases that are still in the support cycle) will continue to be supported through its lifecycle and Microsoft is committed to fix any major, production blocking issues found in these releases." (Microsoft Connect)

    The mainstream support for CE 4.0 will end on 2016-07-12 and extended support 2021-07-13 unless they release a new service pack, which I see as doubtful (Microsoft Support).

    Support for SSCE has also not been included in Visual Studio 2013 and SQL Server 2014 Management Studio.  Erik's SQL Server Compact Toolbox can be used to add support back to VS2013 (CodePlex).  SQL Server CE has even now been removed from the SQL Server website.  It still shows up in search results from Microsoft search (Micorsoft) but sometime back in March or April the page was removed (Wayback Machine).

    There are a couple of UserVoice suggestions asking for Microsoft to support and develop SQL Server CE further:

    Support Sql Server Compact in VS2013

    Sql server Compact 5

    So overall even though nothing has been announced it seems pretty clear to me that Microsoft are not continuing development of SQL Server CE and do not want people to use it.  It's dead!

    Friday, June 27, 2014 2:21 AM