Tuesday, August 15, 2006

Visual Studio 2005 : Prepare for SQL Server Everywhere

MSDN - Visual Studio 2005 : Prepare for SQL Server Everywhere

"Introduces SQL Server Everywhere Edition, a slimmed-down version of SQL Mobile. SQL Everywhere removes the restrictions that keep the SQL Mobile product from running on a desktop or laptop, making SQL Everywhere the ideal, lightweight database for many scenarios. (18 printed pages)

Microsoft recently announced that it will be evolving the SQL Mobile product into a product named SQL Server Everywhere Edition. SQL Mobile is currently a database that you can use on "mobile" devices, which include Tablet PCs, Pocket PCs, and Smartphones. SQL Mobile differs from SQL Server in that with SQL Mobile, there is no "server" running as a background process. The engine for SQL Mobile consists of a handful of DLLs that you reference from your application. When you want to connect to a database, you just put the path to the database file in your connection string. In fact, working with SQL Mobile feels a lot like working with an Access/Jet database. The limitation for SQL Mobile, today, is that it will only run on "mobile" devices. In other words, you can't deploy an application that uses SQL Mobile to desktops or laptops.

..."

This article provides a light weight intro using SQL Server Everywhere in a VS2005 WinForm/ClickOnce project.

I'm looking for the release of SQL Server Everywhere (SSE? SQLSE? SQLE?). I totally dig how easy it is to deploy and use.

Is this good bye to the billion (or so) Access/JET MDB's used by so many full client apps? I will be for me...

No comments: