Well, after several name changes, power outages, the holidays, and crippling winter storms, we’ve released SQL Server Compact Edition 3.1. http://www.microsoft.com/sql/compact
While not required to use SQLce 3.1, you can get the benefit of the new ClickOnce deployment features with Visual Studio Service Pack 1
This will add the ClickOnce bootstrapper, and |DataDirectory| macro to the connection strings. It also includes several bug fixes in the data tools for SQLce.
For more info, there’s plenty of info here on my blog, including screen casts and samples. Pay no attention to the multiple names. The features have remained the same, and like fine wine, the product continues to improve.
- Screencasts of SQL Server Compadct Edition
- ADO.net Programming options for SQL Server Compact Edition
- Screencast of Deployment Options for SQL Server Compact Edition
- Doc storage in SQLce and the 4gb limit
- Comparing SQL Server Express and Compact Editions Whitepaper
- SQL Server Compact Edition under ASP.net and IIS
- Live From Redmond WebCast: Offline Data Synchronization and Caching for Smart Clients
- Bill Vaughn’s eBook on SQL Server Compact Edition
- Dr. Dobbs Article on SQL Server Compact Edition
For additional info:
- The product team has renamed their blog and can be reached at: http://blogs.msdn.com/sqlservercompact
- SQL Server Compact Edition public forums are at: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1
Please help me congratulate the SQL Server Compact Edition product team as they’ve been extremely busy shipping SQLce 3.1, finishing up SQLce 3.5 for Orcas, completing Vista compat, shipping device and Yukon service packs, and still finding time to work on new investments. They’ve been a great team to work with and I’m sure they’d love to hear from you.
Well, as noted, we’re finishing up the fist beta for the next release, SQL Server Compact Edition 3.5 and the new Sync Service for ADO.NET. We’ve sent out some bits to a few customers and are working on getting the public forums setup for a public CTP. Between the holidays, the local power outages, the crippling snow storms, and getting everything ready for the first beta of Orcas, everyone has been pretty busy. If you’ve asked about the CTP, and didn’t receive the bits, don’t worry, it’s coming. We could only manage a few customers until the forum gets setup. There’s still plenty of opportunity to get us feedback, so just a bit more time.
Thanks for all the feedback and patience,