BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

SQL Server Compact Edition Released

| by Jonathan Allen Follow 129 Followers on Feb 02, 2007. Estimated reading time: 1 minute |

SQL Server Compact Edition has been released. As we reported in September, this product is being positioned as a replaced for the venerable Jet engine traditional used by Visual Basic programmers for lightweight databases.

SQL Server Compact has had several names in the last few months, including SQL Server CE, SQL Server Mobile, and SQL Server Everywhere. All of them are a bit misleading, as SQL Server Compact Edition is not based on SQL Server.

Unlike all the other products listed under the title SQL Server, SQL Server Compact is not really a server at all. Like Jet, the engine used for Access, this edition comes as a set of libraries that run in-process. This makes SQL Server Compact ideal for situations were managing a service is not feasible. From the user's perspective, SQL Server Compact is just like any other stand-alone file format.

As it lacks stored procedure support, SQL Server Compact will probably not replace SQL Server Express for small business applications. SQL Server Express also has the advantage of a direct upgrade path to the full version of SQL Server.

Deployment and performance comparisons between SQL Server Compact and other lightweight databases are not yet available.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT