I'm thinking of using SQL Server Compact edition in an existing commercial product, which will be in service for at least 5 years. I notice that mainstream support ends this year, and extended support in 2021. The whole-database encryption feature in the
Compact edition makes it much more suitable than the column-level encryption in SQL Server Express, but if Compact is approaching end-of-life, it's not a good choice.
Is there any official or unofficial information about whether SQL Server Compact will be supported and upgraded in future? Failing that, do Microsoft have any plans to implement whole-database encryption in SQL Server Express?