locked
Is there a what's new for 3.5 SP2 beta? RRS feed

  • Question

  • I noticed it in the VS 2010 beta2 install and I couldn't find any information on the web.
    Tuesday, October 20, 2009 7:58 PM

Answers

  • The information should be up soon.

    Putting some up for you in the meanwhile:


    SQL Server Compact 3.5 SP2 Beta 2 is available for download from the Web at http://www.microsoft.com/downloads/details.aspx?FamilyID=411ba1c5-ba57-45b6-9148-91bed6e7a9f1&displaylang=en. It will also release with the next CTP of SQL Server 2008 R2. The features and improvements in this release are as given below:

    1.    The change tracking used by Sync Services for ADO.NET or Sync FX has been exposed as a public API – System.Data.SqlServerCe.SqlCeChangeTracking. The API documentation is in the process of being published to MSDN Online. With the exposing of the API, Compact’s change tracking can be used independently of Sync Services or Sync FX for tracking inserts, updates and deletes in the database.

    2.    The Transact SQL Editor in Visual Studio 2010 Beta 2 works with Compact. Using the Editor queries can be run against Compact and optimized using estimated and actual show-plans.

    3.    Compact 3.5 SP2 is shipping the CRT 80 runtime. Customers deploying Compact on platforms like XP Embedded were also forced to deploy CRT80 or had to ensure that .NET FX 2.0/3.0/3.5 was installed on the machine because that in turn deployed CRT 80. This was creating deployment issues and can become more problematic in the future with the release of the .NET FX 4.0 as it deploys CRT 100. See http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/4cbde97a-5441-4140-9f8b-6edd48eb17e5/ for more details.

    4.    All released QFEs for Compact 3.5 SP1 and 3.1 have been rolled up in Compact 3.5 SP2. There have been 14 QFE releases for Compact 3.1 and 13 for 3.5 SP1

    5.    Tested and certified against .NET FX 2.0/3.0/3.5/4.0 and their SP’s client and full versions. UI enhancements were done for Compact in VS 2010 Beta 2 UI.

    6.    High priority bug fixes like the one given below (& several other bug fixes):

    a.     SqlCeEngine.Verify(VerifyOption.Enhanced) returns false when any indexed column has blank string ('') data

    b.    Access Violation in SQL Server Compact v3.5 SP1 due to version mismatch

    c.     Re-visit the design for the SchemaTable and make sure SQLCE command builder auto generated update query is correctly generated

    7.    Supported platforms has been extended to the new platforms like Windows 7 all SKUs, Windows 2008 R2 all SKUs, Windows Mobile 6.5

     

    We are also trying to chain in the 64-bit Compact 3.5 SP2 MSI in all Visual Studio 2010 SKUs by RTM so that the F5 compile time error that comes when compiling an app with the Any configuration on a 64-bit machine is fixed. Also the 64-bit MSI will be integrated in Click Once and can be deployed using Click Once.

     

     

     

     


    Member, SQL Server Compact. (Please hit Yes if this was the answer to your question) "The above post is "AS IS" without warranties and confers no rights."
    Wednesday, October 21, 2009 2:00 PM
    Answerer
  • I have posted some info here, which supplements Ravi's info below: http://erikej.blogspot.com/2009/10/whats-new-in-sql-server-compact-35-sp2.html
    http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.
    Wednesday, October 21, 2009 6:06 PM

All replies

  • The information should be up soon.

    Putting some up for you in the meanwhile:


    SQL Server Compact 3.5 SP2 Beta 2 is available for download from the Web at http://www.microsoft.com/downloads/details.aspx?FamilyID=411ba1c5-ba57-45b6-9148-91bed6e7a9f1&displaylang=en. It will also release with the next CTP of SQL Server 2008 R2. The features and improvements in this release are as given below:

    1.    The change tracking used by Sync Services for ADO.NET or Sync FX has been exposed as a public API – System.Data.SqlServerCe.SqlCeChangeTracking. The API documentation is in the process of being published to MSDN Online. With the exposing of the API, Compact’s change tracking can be used independently of Sync Services or Sync FX for tracking inserts, updates and deletes in the database.

    2.    The Transact SQL Editor in Visual Studio 2010 Beta 2 works with Compact. Using the Editor queries can be run against Compact and optimized using estimated and actual show-plans.

    3.    Compact 3.5 SP2 is shipping the CRT 80 runtime. Customers deploying Compact on platforms like XP Embedded were also forced to deploy CRT80 or had to ensure that .NET FX 2.0/3.0/3.5 was installed on the machine because that in turn deployed CRT 80. This was creating deployment issues and can become more problematic in the future with the release of the .NET FX 4.0 as it deploys CRT 100. See http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/4cbde97a-5441-4140-9f8b-6edd48eb17e5/ for more details.

    4.    All released QFEs for Compact 3.5 SP1 and 3.1 have been rolled up in Compact 3.5 SP2. There have been 14 QFE releases for Compact 3.1 and 13 for 3.5 SP1

    5.    Tested and certified against .NET FX 2.0/3.0/3.5/4.0 and their SP’s client and full versions. UI enhancements were done for Compact in VS 2010 Beta 2 UI.

    6.    High priority bug fixes like the one given below (& several other bug fixes):

    a.     SqlCeEngine.Verify(VerifyOption.Enhanced) returns false when any indexed column has blank string ('') data

    b.    Access Violation in SQL Server Compact v3.5 SP1 due to version mismatch

    c.     Re-visit the design for the SchemaTable and make sure SQLCE command builder auto generated update query is correctly generated

    7.    Supported platforms has been extended to the new platforms like Windows 7 all SKUs, Windows 2008 R2 all SKUs, Windows Mobile 6.5

     

    We are also trying to chain in the 64-bit Compact 3.5 SP2 MSI in all Visual Studio 2010 SKUs by RTM so that the F5 compile time error that comes when compiling an app with the Any configuration on a 64-bit machine is fixed. Also the 64-bit MSI will be integrated in Click Once and can be deployed using Click Once.

     

     

     

     


    Member, SQL Server Compact. (Please hit Yes if this was the answer to your question) "The above post is "AS IS" without warranties and confers no rights."
    Wednesday, October 21, 2009 2:00 PM
    Answerer
  • I have posted some info here, which supplements Ravi's info below: http://erikej.blogspot.com/2009/10/whats-new-in-sql-server-compact-35-sp2.html
    http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.
    Wednesday, October 21, 2009 6:06 PM