Sql Server 2005 Everywhere Edition
Tired of deployment problems with Sql Server? Ever wished that your database is just contained in a single file? Well, your wished has just been granted! Welcome to Sql Server Everywhere!
Sql Server Everywhere is a light-weight database solution designed for easy deployment. It’s a file based Sql Server that caters desktop and mobile applications. So what’s its difference with Sql Server Express? Sql Server Everywhere is designed to be used only by a single application. It means that it doesn’t support a multi-user interface. Only one user would be able to access your database at a time. Well, for me it isn’t that bad. If your developing an application that would only be used by one computer then Sql Server Everywhere is the right solution for you. Since the qualms of programmers is that Sql Server eats a lot of resources, even if you only need a simple database solution. That’s why other programmers are resulting into using Access instead of Sql Server. The problem I see with this is Access’ Sql compatibility. Some Sql Statements doesn’t work well in Access and this causes some kind of confusion on the part of the programmer.
Sql Server Everywhere is a file based Database Solution. Which means that each database is just contained in a single file and you access them directly. The beauty of this new technology is its ability to upgrade to a full Sql Server specs in case a multi-user environment would be implemented.
Here's a table comparing Sql Server Everywhere and Sql Server Express:
|
When to use / benefits |
| • |
Essential relational database functionality in a compact footprint |
| • |
Ideal for mobile and desktop applications, including occasionally connected |
| • |
Embeddable in applications |
| • |
Free to download, develop, deploy, and redistribute | |
| • |
Ideal for small server deployments as well as desktop applications with more rich requirements such as full text search and powerful XML query processing. |
| • |
Seamless upgrade to SQL Workgroup, Standard and Enterprise |
| • |
Free to download, develop, deploy, and redistribute | |
|
When not to use |
| • |
When you want to run as a service |
| • |
When you need a multi-user database server |
| • |
You need the full functionality of SQL Server | |
| • |
When the footprint and memory requirements need to be compact |
| • |
When you want to run in process |
| • |
When you want to target devices | |
Other resources:
Sql Server Everywhere Edition
Download Sql Server Everywhere CTP