Hello, Is there an alternate to SQL Server Compact Edition which won't be supported by MS beyond July 2021. It is needed for our Windows Desktop product built in C#.Net.
Hello, Is there an alternate to SQL Server Compact Edition which won't be supported by MS beyond July 2021. It is needed for our Windows Desktop product built in C#.Net.
Hi,
SQL Server Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications
Thanks @ErikEJ and @Criszhan-msft for your recommendations.
Still, I have a couple of questions regarding SQLServer CE:
If SQLServer CE is still continued to use in our product, will there be any issues/impact on our product beyond July 2021?
If yes, what kind of impacts we can anticipate ?
@Criszhan-msft , we have concerns over using SQL Server Express.
as per https://dzone.com/articles/comparison-sql-server-compact
size (>120 MB), and
unlike CE it doesn't run in the same application process
these are major pain points going with SQL Server express.
Please help me to get clarity on these queries.
Hi,
SQL Server Express needs to be installed on the computer(service). And it will take up more space. This is the regular on-premises SQL Server version, like SQL Server Enterprise, Standard Edition.
You might consider using SQLite, VistaDB mentioned by ErikEJ.
re 1; No one can predict the future! But I am guessing that SQL CE 4.0 will continue to work on Windows for years to come.
re 2: A potential impact could be a change in Windows preventing SQL CE from working, but I think that is quite unlikely.
12 people are following this question.