Compartilhar via

SQL Server Compact Edition 3.1 Released

  • Artigo

Well, after several name changes, power outages, the holidays, and crippling winter storms, we've released SQL Server Compact Edition 3.1.  https://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.  

For additional info:

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.    

What's next?

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,

Steve

Comments

  • Anonymous
    January 16, 2007
    Nice post. Love the product. Its made our work as a partner so much easier, with the work you guys put in. Have the next snow storm on us :-)

  • Anonymous
    February 09, 2007
    I love SSCE, its like a dream come true! Are there any plans for an x64 version? I tried deploying a .NET app that used SSCE with the AnyCpu tag on an Vista x64 system... that was fun :)

  • Anonymous
    February 24, 2007
    The comment has been removed

  • Anonymous
    February 24, 2007
    Hi Jamome, Thanks’ for the reminder.  Let me ask the perf team for the status of the paper.   Steve

  • Anonymous
    February 24, 2007
    Great answer Steve, kind of the answer I was sort of looking for. I'll be looking forward to a 64-bit release :)

  • Anonymous
    March 13, 2007
    A bit of confusion here - your blog and some pages refer to 3.1 edition.  Yet the sqlce when installed still is named sqlcecompact30.dll, so I'm not sure whether it is 3.0 or 3.1 for Windows CE installation.

  • Anonymous
    March 17, 2007
    Hi Casner, For SQLce 3.1 we wanted to maintain backwards compat, and leverage all the 2005/3.0 designer and runtime support so we didn't actually change any of the physical versions.  In reality, the 3.1 release was really about unlocking the device scenarios on the full desktop.  SQLce 3.5, currently in CTP will have the native and managed dlls names changed to support full side by side of 3.x and 3.5.  In hindsight, we probably should have made the 3.5 version 4.0 as it does have new feature work.   Steve

  • Anonymous
    July 25, 2007
    Dear Sir, We are using SQL Server Compact Edition 3.5 and the front end is Visual Studio 2005 (VB.NET) windows application. We have some questions listed below:

  1. What 3 ways to create a database (if possible give me a sample code)? and tell me the advantage of this 3 way.
  2. We have a database in MsAccess97 its about 450 MB. We converted those datas into SQL Compact Edition 3.1 (.SDF format) it comes to 1.3 GB. Why its taking so much size? If any solution for this it will bge very helpful for us.
  3. We found there is an option in the Provider String called "Encrypt Database=True;". We have used this option in our project but we don't find any changes happened in the database.
  4. We are using a SQLCE database (1.3GB) in our application. While querying a table will take a minimum of 1 minute to retrieve the datas even though we did the Indexes for all the tables.. Awaiting for your response. Thanks M. Gopalan Sofist India 70, Thyagaraya Rd, T. Nagar Chennai 600017 Tamil Nadu, India www.sofist.com gopalan@sofist.com  

  • Anonymous
    July 26, 2007
    The comment has been removed

  • Anonymous
    August 20, 2007
    Any news on the 64-bit version? Our application cannot be supported on Vista x64 until SQLCE works on 64-bit.

  • Anonymous
    August 23, 2007
    Hi Norpe, Nothing more specific to report beyond what I've posted here just yet: http://blogs.msdn.com/stevelasker/archive/2007/07/11/sql-server-compact-and-64bit-support.aspx I can say that we're actively working on portions of the 64bit scenarios, but really the team is focused right now on getting VS 2008 done, as well as SQL Server 2008.  As soon as we get that done we can get the 64bit work started.  We're still confident we can get it done as stated above, As for your Vista 64 app, WOW mode won't buy you the time?

  • Anonymous
    August 17, 2009
    Steve, I am trying to use the .sdf file through native c++ in linux system. I would appreciate any suggestions / sample code. Thanks, Ganesh Raju