none
Future or SQL Server Compact Edition / Alternatives RRS feed

  • Question

  • Hi,

    in this MS-Connect-Entry i've read that SQL Server Compact Edition is in Deprecation Mode:

    https://connect.microsoft.com/SQLServer/feedback/details/776328/port-sql-compact-to-windows-rt

    As far as i see there is no real alternative from Microsoft if i have the following requirements:

    - Local, light weight Database

    - No Install required (only XCopy-Deployment)

    - Run in User-Mode without Administrative Privileges

    So my question is: 

    Why are you deprecating a product without providing a real alternative to it? 

    What solution do you suggest your customers with the requirements above?

    I've seen the possibility of using SQLite but i would actually prefer a product coming directly from Microsoft.

    Thanks!

    Best wishes

    Markus


    Tuesday, October 21, 2014 7:31 AM

Answers

  • Yes, stiil waiting for an official statement from MS.

    In the meantime, notice that SQL Server Compact is still supported on Windows Server 2012 R2/Wndows 8.1 


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

    Tuesday, October 21, 2014 8:20 AM
    Moderator
  • Then why not proceed with SQL Compact for now, and hope that SQLite gets fixed in the mean time?

    Suggest you log an issue at system.data.sqlite.org - the more requests they get the more likely that they will spend resources on a fix


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

    Wednesday, October 22, 2014 9:35 AM
    Moderator

All replies

  • Yes, stiil waiting for an official statement from MS.

    In the meantime, notice that SQL Server Compact is still supported on Windows Server 2012 R2/Wndows 8.1 


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

    Tuesday, October 21, 2014 8:20 AM
    Moderator
  • Hi Markus,

    Agree with ErikEJ. And as is mentioned in this article, SQL Server Compact 4.0 is supported until 2016. 

    Currently, besides the SQLite product, you can also use SQL Server Express or SQL LocalDB. LocalDB is created specifically for developers. It is very easy to install and requires no management, and it offers the same T-SQL language, programming surface and client-side providers as the regular SQL Server Express. The regular SQL Server Express will continue to exist as a free SQL Server edition, fully compatible with and easily upgradeable to higher SQL Server editions.

    Here is a blog about SQL Express, LocalDB and SQL Compact Edition for your reference.
    http://blogs.msdn.com/b/jerrynixon/archive/2012/02/26/sql-express-v-localdb-v-sql-compact-edition.aspx


    Thanks,
    Lydia Zhang




    Wednesday, October 22, 2014 6:03 AM
    Moderator
  • Hi Erik and Lydia,

    thank you for your replys!

    Well i know SQL Compact is supported until 2016 but it would make me feel totally uncomfortable if i would start a project now - end 2014 - using SQL Compact, knowing i'm betting on a dead horse!

    Also SQL LocalDB is no real alternative because it needs an installation, administrative privileges and so on.

    So if my customer insists on having an X-Copy-Deployment without the need for any MSI package installation i could not use this.

    SQL Lite unfortunately has a lot of problems if i want to use it with Entity Framework. In fact it just doesn't work anymore with Visual Studio 2013 Update 3. 

    So for my eyes there is no real satisfying alternative without big disadvantages.

    Best wishes 

    Markus


    Wednesday, October 22, 2014 8:40 AM
  • Then why not proceed with SQL Compact for now, and hope that SQLite gets fixed in the mean time?

    Suggest you log an issue at system.data.sqlite.org - the more requests they get the more likely that they will spend resources on a fix


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

    Wednesday, October 22, 2014 9:35 AM
    Moderator
  • I also would like an official statement. When MSFT was really pushing SQLCE a few years back I moved to it. Now... it seems like Microsoft doesn't want to bother with it anymore. But no official statement + plans on what will be provided from Microsoft. I am very familiar with SQL Express, SQL Server and LocalDB.  But all are heavy-weight compared to SQLCE.  Really, SQLCE makes a great replacement for Access/JET. Not sure why we're hung out to dry.

    Thursday, January 1, 2015 10:44 PM
  • It should also be noted that LocalDB doesn't work under IIS.

    The SQLExpress blog has two parts describing the hacky workarounds:

    But it's clear that LocalDB is meant for developers - not production. It's meant to be a bulkier, harder to install, alternative to SQL Sever Compact Edition. 

    It's meant to be easier to install than SQL Server Express because you....still have to install it machine-wide...

    Sunday, June 26, 2016 3:42 PM