SQL Server Compact 3.5 Downloads


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 Mishra


Program Manager – SQL Server Compact


 

Comments (13)

  1. BestSnowman says:

    Is there any support for 64-bit OSes yet? I have been having trouble running SqlMetal on Vista x64 getting errors. Is 64-bit support something in 3.5, or something beyond?

  2. Steve Lasker says:

    Hi Best…

    Here’s a post on our 64bit plans. http://blogs.msdn.com/stevelasker/archive/2007/07/11/sql-server-compact-and-64bit-support.aspx

    As for SQLMetal, you’ll need to manually run the B2 version in WOW mode, and will be fine. In RTM, SQLMetal will automatically run in WOW mode.  

    Steve

  3. SQL CE Team says:

    Hi Best…

    Here’s a blog post explaining our 64bit release plans. http://blogs.msdn.com/stevelasker/archive/2007/07/11/sql-server-compact-and-64bit-support.aspx

    For SQLMetal, you’ll need to manually run in WOW mode for Beta 2. We just didn’t get this done before shipping B2 . The final release will automatically run in WOW mode.

    Steve

  4. ErikEJ says:

    Maybe a small feature, but worth mentioning none the less:

    sp_rename allows you to rename a table in SQL Compact 3.5.

    For a walkthrough see my blog: http://erikej.blogspot.com/2007/08/hidden-gem-rename-table.html

  5. BestSnowman says:

    Thanks, I now remember seeing that blog post (talk about short term memory 🙂 ) Its good to hear that its still on the roadmap. Thanks for the great product, hard not to get antsy waiting for new features 🙂

  6. itd says:

    Hi,

    I’m afraid can’t see the differences between “Platform Default” and “Engine Default” encryption modes… there are any??

  7. SQL CE Team says:

    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

  8. tech_tantra says:

    Hi Ambrish,

    Could you pls help me clearing my doubts on SQL CE 3.5

    I have the following scenario as below:

    My development environment is VS 2005 and my Database is SQL Server 2005 (Enterprise).

    Now the requirement is to develop a mobile application which would run on windows mobile 5.0 and also to have a feature of synchronizing data from mobile database to the sql server database. I have researched on Merge Replication, RDA and ADO.Net sync and of the three I believe the best bet would be ADO.Net sync.

    I would also agree with Steve that I can initially develop the sync logic for windows and then move it to the device.

    But I have some more questions with ref to application development for the device.

    I have installed the SQL CE database on my pocket pc running Windows Mobile 5.0 by making use of the cab provided in the link below

    The location from where I have downloaded is http://www.microsoft.com/downloads/details.aspx?FamilyId=4CC8F083-6418-4587-9796-88436E117621&displaylang=en

    I am providing the link just to make sure that we both are talking about the same SQLCE3.5 edition (I am sorry I am bit confused with the number of releases available)

    I have also installed the SQLCE3.5 on my dev machine (Win XP having VS 2005) to access the API’s.

    Now can I start developing using VS2005 referencing the dll’s of SQL CE3.5 in my VS 2005.

    I mean can I atleast start writing win mobile based application targeting sql ce 3.5 (leaving apart the sync functionality)

    The forum below gives an way of doing it, just want to make sure this would be the right approach.

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1775261&SiteID=1

    I understand that there is also a way available to upgrade the database developed for SQLCE3.0 to SQLCE3.5 with an ugrade() method.

    So can I create the sdf files targeted towards SQL CE 3.5 and start developing db applications in vs 2005 and the later on include the sync functionality.

    Or can I develop my applications which are targeted on SQL CE 3.0 and later migrate to SQL CE3.5 so that I can benefit the sync functionality, is that possible.

    Also when is a target date of release for VS 2008 for development purpose

    It would be great if you can get these points cleared.

    Thanks a lot for all the help.

    Regards

    Rajesh

  9. Calanis says:

    Hi,

    I need to connect SQL Server Compact 3.1 with Orcas Beta 2,

    i found tons of examples but using VS 2005 and they dont work with Orcas

    any idea?

  10. itd says:

    fyi:

    I just shared an user interface vs2008 project for use sqlmetal.exe tool. The code is in codeplex.com/sqlmetalosui

  11. SQL CE Team says:

    Hey Calanis,

     Sorry for the late reply.

     VS 2005 is integrated with SQL Server Compact 3.1.

     VS 2008 is integrated with SQL Server Compact 3.5.

     So, if you are using VS 2008 please upgrade from SQL Server Compact 3.1 to SQL Server Compact 3.5.  

    Thanks,

    Laxmi

  12. Cannot_download.NET says:

    If i try to download " SQL Server Compact 3.5 and Synchronization Services for ADO.Net v1.0 for Windows Desktop" i got the following message:

    "We’re sorry, but there is no Microsoft.com Web page that matches your entry. It is possible you typed the address incorrectly, or the page may no longer exist. You may wish to try another entry or choose from the links below, which we hope will help you find what you’re looking for."

    Does anybody know the correct link adress?

  13. SQL CE Team says:

    The Synchronizarion Services for ADO.Net v1.0 and SQL Server Compact 3.5 is available for download at http://www.microsoft.com/sql/editions/compact/downloads.mspx

    Rajesh,

    Apologies for the late response. I hope that you have been able to use Visual Studio 2008 for developing your application. There is a CTP available for download for Synschronization Services for ADO.Net for Windows Mobile devices at http://www.microsoft.com/downloads/details.aspx?FamilyID=75FEF59F-1B5E-49BC-A21A-9EF4F34DE6FC&displaylang=en

    Regards

    Ambrish