# Thursday, January 18, 2007
« Identity Theft Made Easy? | Main | January Utah County .NET User Group (UCN... »

I got this announcement this morning in my e-mail. I thought it would be of interest to some of you:

 

I just wanted to share some new release information with you regarding SQL Server Compact Edition – Formerly known as SQL Server Everywhere Edition, SQL Server Mobile, and yes, SQL Server CE.

In addition to Bill Vaugn’s eBook, Scott Swigart interviewed a few of us for Dr. Dobbs.  

 

 

SQL Server 2005 Compact Edition RTW. 

 

Despite name changes, power outages, holidays and crippling snow storms, the SQL Server 2005 Compact Edition team would not be denied.  Monday, January 15th at 10am, weighting in at 1.7mb, the newest member of the SQL Server family was released to the web for download.  With SQL Server Compact Edition 3.1, Microsoft continues to deliver on the client platform investments demonstrating the ability to quickly respond to customer’s request.  Rather than wait for the next major release of Visual Studio or SQL Server, and just a year after Visual Studio 2005 and SQL Server 2005 shipped, Microsoft ships SQL Server Compact Edition 3.1 to deliver on the next generation of client applications. 

Visual Studio Orcas, the next major release of Visual Studio will deliver yet another release of SQL Server Compact Edition building on the needs for cached and occasionally connected client applications.   Visual Studio 2005, coupled with Visual Studio Service Pack 1 which unlocks a number of the new Compact Edition features, has a number of designer and tooling features enabling rapid development with Compact Edition.  

 

http://www.Microsoft.com/SQL/Compact

---

Product Overview & Resources

SQL Server 2005 Compact Edition extends the SQL Server Mobile Edition technology by offering a maintenance free, compact embedded database for client applications for all Windows Platforms including Tablet PCs, Pocket PCs, Smart Phones and Desktops that supports in-memory processing.  In addition, SQL Server Compact Edition is free to deploy and free to redistribute.

SQL Server Compact Edition application scenarios include:

  • Connected applications that require local storage w/query processing, transactions in a compact footprint
  • Occasionally-connected & offline clients
  • Embedded in applications & devices

SQL Server Compact Edition shares a common programming model with the other SQL Server editions, enabling developers to transfer skills and knowledge quickly and easily.  The product offering includes a maximum database size of 4 GB, runs in-process with application, subset of T-SQL, ADO.NET support including rich data access via scrollable cursors and flexible sync technologies - all in a compact footprint that can be privately deployed within your application.

 

SQL Server Compact Edition customer ready resources include:

 

·          SQL Server 2005 Compact Edition Features Datasheet

·          White Paper: SQL Server Compact Overview

·          White Paper: Choosing Between SQL Server Compact and SQL Server Express

---

For Additional Information

§          Steve Lasker’s blog w/Screencasts, demos and powerpoints

§          SQL Server Compact Edition Product team Blog