Click here to Skip to main content
15,879,535 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
Hi
I'm wondering if Sql CE is suited as a database engine for a website. I know that it's possible. But is it safe (or as safe as SQL Server)? Or do I have to overthink a few things when I want to choose for Sql CE? I'm aware of the limitations (No SP, no views,...) of Sql CE, those aren't a problem for the site I need to create.

Many thanks in advance!

Greetings
Posted

1 solution

I would recommend the SQL Express, formerly known as MSDE in that it is the free version so if you do not have to run on compact edition (and why would you run a database there), then use the most available of the MSSQL's if you don't have a budget to buy another, it is quite good
http://msdn.microsoft.com/da-dk/evalcenter/dn434042.aspx[^]

alternatively consider Microsoft Azure SQL which has intersting alternative offerings for a database or even MySQL which is very able and fast and free
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900