SQL Server Everywhere

Finally, a small footprint version of SQL Server, which doesn’t run as a service. Does this finally mean we have a suitable replacement for Access mdb files?

Robert Burke’s Weblog : SQL Server 2005 Everywhere Edition – lightweight, flexible, free datastore

[tags]microsoft, sqlserver, sql, access, sqlite[/tags]

This entry was posted in Code. Bookmark the permalink.

3 Responses to SQL Server Everywhere

  1. AndyF says:

    Another suitable replacement has existed for some time now: SQLite! I use it extensively in an app that also uses Flickr.Net. It comes up a bit short on the design tool side, but it’s hard to beat its footprint, performance, and licensing terms. Not to mention cross platform support if that is important.

  2. Sam says:

    Excellent, will definately check that out.

    I assume you use the SQLite ADO.Net Provider:

    Their web site: http://adodotnetsqlite.sourceforge.net/

  3. Sam says:

    Oh, and for a ADO.Net 2.0 Provider (which appears to be more complete than the above)

    try:

    http://sourceforge.net/projects/sqlite-dotnet2