November 12, 2019
Hot Topics:

A First Look at SQL Server Everywhere

  • August 28, 2006
  • By Mike Gunderloy
  • Send Email »
  • More Articles »

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.

Page 2 of 2

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date