sticky
SQL Server Compact 3.5 Downloads

    General discussion

  • Microsoft SQL Server Compact 3.5 released with Visual Studio 2008. The English release of SQL Server Compact 3.5 is available on the download center and the links are as given below:

     

    1. SQL Server Compact 3.5 and Synchronization Services for ADO.Net v1.0 for Windows Desktop: Installs the files for SQL Server Compact 3.5 and Microsoft Synchronization Services for ADO.Net for Windows Desktop platform

     

    2. SQL Server Compact 3.5 for Windows Mobile: The download contains the CAB files and DLL’s that are used to install SQL Server Compact 3.5 on the Windows Mobile Devices platform

     

    3. SQL Server Compact 3.5 Server Tools: Installs the Server Tools on the IIS server enabling merge replication and remote data access (RDA) with SQL Server 2005 and later.

     

    4. SQL Server Compact 3.5 Books Online and Samples: The download contains SQL Server Compact 3.5 Books Online, Online Read Me and Samples. SQL Server Compact 3.5 Books Online do not install with Visual Studio 2008. The Books Online are only available on the Web.

     

    5. Synchronization Services for ADO.Net v1.0 Books Online: Synchronization Services provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. The Books Online has more information about Synchronization Services. The forum for Synchronization Services provides technical Q&A about using Synchronization Services.

     

    Visual Studio 2008 is the development environment for SQL Server Compact 3.5. Visual Studio 2008 installs SQL Server Compact 3.5 Design Tools, SQL Server Compact 3.5 for Windows Desktop and SQL Server Compact 3.5 for Windows Mobile. SQL Server Compact 3.5 Design Tools installs the SQL Server Compact 3.5 design-time components with Visual Studio 2008 and is not available as a separate Web download. The design-time components are the user interface, dialog boxes, and design-time environment, which are used to write applications for SQL Server Compact 3.5. 64bit versions of Windows are supported under WOW64 mode until a native 64bit release is available.

     

    Support Options:

    Your feedback is important to us.

    • Help improve SQL Server Compact by submitting and tracking bugs using Microsoft Connect website. Be sure to select SQL Server Compact as the version and provide detailed repro steps to help us identify the problem
    • Contact Microsoft Professional Support. For deeper support needs, purchase a Professional Support package and have experts available 24 hours a day, seven days a week, and 365 days a year
    • Find out what support options are available if you are located outside the United States or Canada at Worldwide Support Options
    • Search the Knowledge Base Articles. Get the answers you need about SQL Server Compact from the Microsoft Knowledge Base. This is the same database of technical articles used by Microsoft Support Professionals
    • To participate in the future SQL Server Compact Technology Adoption Program (TAP), please send us an email

    SQL Server Compact 3.5 introduces the following features for software developers.

    Installation and Database File Upgrade

    1. Support for side-by-side installation together with the previous version (3.1) on desktop computers. If you try to open database files created by using earlier versions, SQL Server Compact 3.5 will give you a message that the file cannot be opened. To open it, the database file first must be upgraded by using the Upgrade to SQL Server Compact 3.5 Database dialog box in Visual Studio 2008. To access the Upgrade to SQL Server Compact 3.5 Database dialog box, click Data, click Add New Data Source, and then click Add Connection. When you try to open an earlier version of the database file, you receive a message. By selecting OK, the Upgrade to SQL Server Compact 3.5 Database dialog box appears. The file name extension of SQL Server Compact 3.5 is *.sdf, which is the same as that of the earlier versions (SQL Server Compact Edition, v. 3.1, and SQL Server 2005 Mobile Edition, v. 3.0). After a database file is upgraded to SQL Server Compact 3.5, you will no longer be able to open the database file by using earlier versions of SQL Server Compact. Database files created by the earlier versions of SQL Server Compact 3.5 can be programmatically upgraded by using the SqlCeEngine.Upgrade API. Refer to the documentation for more information.
    2. To support older operating systems, with older encryption algorithms, and newer, more secure encryption, SQL Server Compact 3.5 supports backward-compatible encryption modes. The encryption modes available in the Upgrade to SQL Server Compact 3.5 Database dialog box are as described in the following list.
      Platform Default: When you create or upgrade SQL Server Compact databases, Encryption mode will select the default encryption for the operating system. By creating a database on one of the newer platforms shown here, older platforms (such as Windows CE 4.2 or Windows Mobile 2003) will be unable to open encrypted SQL Server Compact files. The older platforms do not support the newer encryption algorithms.
      • Windows CE 5.0
      • Windows CE 6.0
      • Windows Mobile 5.0
      • Windows Mobile 6.0
      • Windows XP
      • Windows Server 2003
      • Windows Vista

      For example, if the database is created on Windows XP, it will select encryption for Windows XP. The encrypted database created on Windows XP with the Platform Default option cannot be opened on Windows CE 4.2 or Windows Mobile 2003 for Pocket PC.

      Engine Default: By default, the encryption mode for the SQL Server Compact 3.5 database file will not work on Windows CE 4.2 or Windows Mobile 2003 Software for Pocket PC. This encryption mode will work on all newer SQL Server Compact 3.5 supported platforms.
      • Windows CE 5.0
      • Windows CE 6.0
      • Windows Mobile 5.0
      • Windows Mobile 6.0
      • Windows XP
      • Windows Server 2003
      • Windows Vista
      PPC2003 Compatibility: While less secure, this option can be used to support older and newer operating systems including:
      • Windows CE 4.2
      • Windows Mobile 2003 Software for Pocket PC
      • Windows CE 5.0
      • Windows CE 6.0
      • Windows Mobile 5.0
      • Windows Mobile 6.0
      • Windows XP
      • Windows Server 2003
      • Windows Vista

    Tools Support

    1. The Visual Basic Express Edition and Visual C# Express Edition of Visual Studio 2008 now fully support SQL Server Compact 3.5-based applications for desktop computers.
    2. Enhanced SQL Server Compact 3.5 Table Designer in Visual Studio 2008 provides a user interface for creating primary key and foreign key relationships between tables.

    Core Database Functionality

    1. Implements the timestamp (rowversion) data type.
    2. Support for Transact-SQL statements has been extended as follows:
      • Nested query in FROM clause
      • CROSS APPLY and OUTER APPLY
      • CAST and DECIMAL
      • TOP
      • SET IDENTITY INSERT

    Data Synchronization

    1. SQL Server Compact 3.5 now includes a new developer oriented, componentized synchronization model by using Synchronization Services for ADO.NET, available for desktop computers only.
    2. Server Tools for configuring Merge Replication and RDA by using SQL Server Compact 3.5 can be downloaded from the Microsoft Download Center. Note that SQL Server Compact 3.5 Server Tools cannot be installed side-by-side with earlier versions of Server Tools on the computer that is acting as the IIS server. SQL Server Compact 3.5 Server Tools can replicate data between SQL Server Compact 3.5 and SQL Server 2005 and later versions. The Server tools can also support synchronization between SQL Server 2005 and SQL Server Compact 3.1. SQL Server Compact 3.5 Server Tools also supports data replication between SQL Server 2005 Compact Edition or SQL Server 2005 Mobile Edition and SQL Server 2005 and later versions.

    Programmability

    1. Supports local TransactionScope on desktop computers.
    2. SQL Server Compact 3.5 supports LINQ to SQL. LINQ to SQL is a component of the LINQ project. It provides a run-time infrastructure for managing relational data as objects, without giving up the ability to query. It translates language-integrated queries into Transact-SQL for execution by SQL Server Compact 3.5, and then translates the tabular results back into the objects as defined by the application developer. There is no designer support for SQL Server Compact 3.5 in LINQ to SQL. The SqlMetal.exe utility must be used for SQL Server Compact 3.5. For more information, see the documentation.

    Regards

     

    Ambrish

    Wednesday, August 01, 2007 12:31 PM

All replies

  • Hi,

    I'm afraid can't see the differences between "Platform Default" and "Engine Default" encryption modes... there are any??

     

    Thursday, September 06, 2007 1:48 PM
  • If a SQL Server Compact 3.5 database is created on a Windows CE 4.2 or Windows Mobile 2003 for Pocket PC the encryption mode will result in the following behavior:

     

    Paltform Default: After creating the database the database can be opened on Windows CE 4.2 or Windows Mobile 2003 for Pocket PC

     

    Engine default: There will be error that the operating system does not support the encryption mode

     

    Regards

     

    Ambrish

     

    Thursday, September 06, 2007 1:58 PM
  • I can't seem to find the header file for native code development. Is it available? If so, where?

     

    TIA

     

    Friday, September 07, 2007 8:46 AM
  • The header files are in the folder %Program Files%\Microsoft SQL Server Compact Edition\v3.5\Include. The header files (sqlce_err.h and sqlce_oledb.h) are installed with Orcas Beta 2.

     

    Regards

     

    Ambrish

    Friday, September 07, 2007 9:34 AM
  • Great Info.

    Thursday, September 13, 2007 7:25 AM
  • I am attempting to use the SQL Server 2008 Developer Edition (Management Studio) to create/manage a Compact Edition 3.5 database. My problem is that I cannot even create/open the compact database in Management Studio. Any help would be GREATLY appreciated. TIA

     

    Problem Creating the Compact Database:

    1. Open 2008 Management Studio
    2. From menu choose File | Connect Object Explorer...
    3. Choose SQL Server Compact Edition as the Server type.
    4. Choose <New Database...> as the Database file.
    5. Browse to folder where file will be created (C:\MyDatabase#1.sdf was used in my example)
    6. Leave all other field as default selections OR make changes, either way it does not work.
    7. Click OK.
    8. At this point the OK button just becomes disabled and nothing happens.

    Problem Opening An Existing Compact Database:

    1. Open 2008 Management Studio
    2. From menu choose File | Connect Object Explorer...
    3. Choose SQL Server Compact Edition as the Server type.
    4. Choose <Browse for more...> as the Database file and locate a ".sdf" file that I created using VS2008.
    5. Enter password, if any.
    6. Click OK.
    7. The following exception is displayed:
      TITLE: Connect to Server
      ------------------------------
      Cannot connect to C:\Documents and Settings\darrinb\My Documents\Visual Studio 2008\Projects\TestSQLCompactEdition35\TestSQLCompactEdition35\AFS.sdf.
      ------------------------------

      ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

      ------------------------------
      Could not load file or assembly 'Microsoft.SqlServerCe.Enumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (mscorlib)
      ------------------------------
      BUTTONS: OK
      ------------------------------
    Thursday, September 27, 2007 11:18 PM
  • With SQL Server 2008 November CTP, the SQL Server Management Studio now allows you to manage and query SQL Compact 3.5 databases.

    Friday, September 28, 2007 8:11 AM
  • Ambrish,

     

    I am working with CE 3.5 Beta 2, and the parser does not understand the SELECT clause in a SELECT subquery. I need to find out if this feature has been implemented in Beta 2. If it has, it must have a different syntax than I am accustomed to. Please respond ASAP - we're on a tight deadline and I don't want to switch horses in the middle of the stream unless I have to.

     

    Dave

     

    Sunday, October 21, 2007 3:05 AM
  •  

    Hi Dave,

     

    SQL Server Compact 3.5 does not support SELECT subqueries. A scalar subquery in SELECT clause like “SELECT  c1, (SELECT MAX(c2) FROM t2) FROM t1” will throw a parsing error.

     

    Regards

     

    Ambrish

    Monday, October 22, 2007 12:32 PM
  • Will SQL Server Compact 3.5 GA support synchronization with SQL Server 2000 SP4 in future?

     

    Thanks

     

    Yuanlei

    Saturday, November 03, 2007 4:58 PM
  • Thanks, Ambrish. I've found that I can move the subquery to the FROM clause and, with a join, come up with the same result. A little more work, but doable.

     

    Out of curiousity, why the subquery limitation in the SELECT clause of CE? SQL Server and Oracle support SELECT subqueries; it's a lot less SQL, and CE is already parsing subqueries correctly in FROM and WHERE.

     

    Dave

     

    Saturday, November 03, 2007 7:10 PM
  • SQL Server Compact 3.5 supports replication with SQL Server 2000 SP4 using the Microsoft Synchronization Services for ADO.Net v 1.0. Replication with SQL Server 2000 SP4 is not supported using remote data access or Merge Replication. There is no plan to support remote data access or merge replication of data between SQL Server Compact 3.5 and SQL Server 2000 SP4

     

    The nested query in the From clause was required for the LINQ to SQL support for SQL Server Compact 3.5. I am logging a bug to support the nested query in Select From clause

     

    Thanks for your feedback

     

    Regards

     

    Ambrish

     

    Monday, November 05, 2007 2:10 PM
  • Did you ever find an answer?

    I''m in the same boat, just installed SQL Server CE v3.5 and appears to be no include dir............where to go?

    Saturday, January 19, 2008 5:24 AM
  • Saturday, January 19, 2008 11:51 AM
  • Updated link: http://social.msdn.microsoft.com/forums/en-us/sqlce/thread/CC9AEC92-4C64-4101-B292-CC26F3202569
    Visit my SQL Compact blog - http://erikej.blogspot.com - Please mark as answer, if this was it.
    Monday, August 09, 2010 11:57 AM
  • hi

    my mobile device (with windows mobile 4.2) use sqlce2.0 but I have changed operating system old server 2003 new win server 2008 r2 

    now server dont connect mobile device database, sqlceexeption error

    help me please

    Friday, December 09, 2011 10:12 PM
  • In order to use the new server, you must also update to SQLCE 3.5 SP2 on the device (and I am not sure 3.5 SP supports Win CE 4.2), and install the 3.5 SP2 server agent, so maybe you should stay at 2003 on the server.
    Please mark as answer, if this was it. Visit my SQL Server Compact blog
    Saturday, December 10, 2011 10:57 AM