question

MohanAyyavu-3464 avatar image
0 Votes"
MohanAyyavu-3464 asked Criszhan-msft commented

alternate to SQL Server Compact Edition

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.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

Hi,

SQL Server Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErikEJ avatar image
1 Vote"
ErikEJ answered

SQLite, VistaDB

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MohanAyyavu-3464 avatar image
0 Votes"
MohanAyyavu-3464 answered Criszhan-msft commented

Thanks @ErikEJ and @Criszhan-msft for your recommendations.

Still, I have a couple of questions regarding SQLServer CE:


  1. If SQLServer CE is still continued to use in our product, will there be any issues/impact on our product beyond July 2021?

  2. 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

  1. size (>120 MB), and

  2. 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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·
ErikEJ avatar image
0 Votes"
ErikEJ answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.