SQL Server Everywhere, not for me

Tuesday, July 11, 2006

From Microsoft.com: "Microsoft SQL Server 2005 Everywhere Edition offers essential relational database functionality in a compact footprint ideal for embedding in mobile and desktop applications including a new generation of occasionally connected dynamic applications." I'm not sure I agree.

Here is my inital list of pros/cons from a developers point of view:
Pros
Completely run in-proc, meaning there is no installation required
Free to develop, deploy and redistribute
Allows up to 4GB databases
Support for up to 256 connections
Very compact (max of 7 DLLs required at 1.4 MB)
Cons
No user interface available (I had to create my database through code)...I'm sure a 3rd party will develop one very soon.
Support for only a limited number of datatypes - for example, supports nvarchar, but not varchar or the XML data type!
Does not support stored procedures, views,  triggers, extended stored procedures, or macros.

Sample Application
The code is not that complicated, so I'm not going to write up a technical explanation. But in my overall opinion, this product seems to be a much more powerful version of Access without the interface. I don't see myself using it anytime soon.

I spent a few hours reading about SQL Server Everywhere and put together this sample application.
Download Sample Application
Form1.cs



Useful links
Downloaded SQL Server Everywhere: http://www.microsoft.com/sql/ctp_sqleverywhere.mspx
Paul Flessner announced SQL Server Everywhere: http://www.microsoft.com/sql/letter.mspx
Steve Lasker's Blog -  Interview with Paul Flessner: http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.aspx

Comments

Dan Fergus
9/7/2006

But you do have an interface. You can use the SQL Server 2005 Management Studio.

Reply
Leave Comment
Yay! You've decided to leave a comment. That's fantastic! Please keep in mind that comments are moderated. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let's have a personal and meaningful conversation instead. Thanks for dropping by!