SQL Server 2005 Everywhere Edition
I just discovered a tasty new Microsoft treat, [SQL Server 2005 Everywhere Edition](http://www.microsoft.com/sql/ctp_sqleverywhere.mspx). It’s super small, portable, and most useful for me, embeddable. Go Microsoft!
From [SteelPrice.net](http://blog.steeleprice.net/archive/2006/06/15/880.aspx)…
* Licensing - Free (essentially the same as SQL Express) now available on XP/2003/Vista as well
* Database Size Limit - 4Gb (not set in stone, but most likely)
* Runtime Size - 1.4Mb - running In Process with your App (including Office Apps for VSTO developers)
* This means no server to install, just some DLLs that are independent from anything else and can just be added/removed without harming any other app on your system.
* Single Data File(.sdf) - no transaction log, etc.
* Sync with a backend SQL Server through Merge & Replication - (More than just RDA soon)
* Differencing Tools in the ADO.NET extensions (MergeUpdated(), MergeInserts(), MergeDeletes())
* Complete control over collision handling so you can choose client wins, Server wins or create a custom solution because you have access to both sides of the colliding row.
* Multi-connection support so you can run multiple background processes on the same file.
* Windows can handle the ACL on the file so you can lock the file to a group of domain users, etc.
This entry was posted on Monday, July 3rd, 2006 at 12:50 pm and is filed under Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
