SQL Server Compact Edition – Still an option for lightweight persistence?

Recently, I was looking for a lightweight database for a small, independent application. One requirement was an easy deployment without installation of additional software on the server. The first thing that came to my mind was SQL Server Compact Edition. Technically it fulfilled all requirements perfectly but than I stumbled across this Connect Article.

“SQL Server compact edition is in deprecation mode with no new releases planned near future”

Sadly this disqualifies SQL Server Compact Edition for the use in a productive application and the recommended SQL Server Express or LocalDB do not really replace it.

Now the big question is, what to use instead of SQL Server Compact Edition for the use case of a lightweight, easy to deploy database on a Windows Server?

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s