A First Look at SQL Server Everywhere, Page 2
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
Mike Gunderloy is the author of over 20 books and numerous articles on development topics, and the Senior Technology Partner for Adaptive Strategy, a Washington State consulting firm. When he's not writing code, Mike putters in the garden on his farm in eastern Washington state.