Introduction to SQL Server Everywhere

Friday Jun 15th 2007 by DatabaseJournal.com Staff

SQL Server 2005 has grown to include more versions of the platform than ever before. One of the newest is SQL Server Everywhere, now known as SQL Server Compact Edition. Jacob Sebastian brings us a great introduction for you to understand how this version disappears from the others and where it can be used.

[From SQL Server Central]

SQL Server Everywhere is a new member in the SQL Server Family. It is a Light-weight, free database which is ideal for small applications for a single user. It is much lighter than databases like MS Access or SQL Server Express and have a disk foot print that is below 2 MB.

SQL Server Everywhere does not have a Server Process at all. The database engine is loaded as an Inprocess component from System.Data.SqlServerCe.dll. This makes deployment and distribution of the application super easy! Being Inprogress would give better performance most of the times.

The article continues at http://www.sqlservercentral.com/columnists/jSebastian/2997.asp

Mobile Site | Full Site