A First Look at SQL Server Everywhere
One Size Doesn't Quite Fit All
You should understand, though, that SQL Server Everywhere is not meant to be the database for everything. It's clearly not meant to handle complex multiuser scenarios or heavy transaction loads. Here are some limits to keep in mind as you try to understand where this is the appropriate technology:
- You can't use SQL Server Everywhere in ASP.NET applications.
- SQL Server Everywhere files don't support any code. That means no stored procedures, views, triggers, macros, or similar objects.
- SQL Server Everywhere does not allow multiple simultaneous users to access the database.
- SQL Server Everywhere databases are limited to 4GB of data.
These constraints should give you the general idea: SQL Server Everywhere is targeted for single-user desktop scenarios, where you've got an application that needs to store data and possibly synchronize it with a server. Within those bounds, though, it's a very attractive solution - and one that you can actively experiment with today.
About the Author
Page 2 of 2