Sql Server Everywhere - the same familiar engine inside a few dlls
I am comfortable with Sql Server and now we have a small footprint, embedable version of it which makes me happy.
While going through the various documentation, the following caught my eye:-
"..Alternatively, SQL Server Everywhere Edition can be deployed by copying the engine files (several DLLs totaling less than 2MB) to the application directory. The former option helps support scenarios where the user does not have administrative rights on the machine. "
Source: http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b404e542/SQLServerEverywhereDatasheet_final.doc
For me personally, this means that I can write web apps with Sql Server Everywhere without having Sql Server hosting. Currently, I would go with Jet mdb files but this opens up another option.
But I need to dig in and see how different it is from Jet and how similar it is to Sql Server 2005.