Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) RTW


Hi,


 


Today we are very pleased to announce the RTW release of Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly.


 


Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Compact Edition database on a device.


 


The salient features of this solution are summarized below


Ø  Provides a synchronization solution between SQL Mobile/SSCE and MS Access. Data conversion is done while synchronizing the data.


Ø  Synchronization happens when there is an active ActiveSync connection between the device and the desktop.


Ø  There is no update to SQL Mobile/SSCE on the device. The solution consists of only of desktop side component which works with the existing client agent on the device.


Ø  The solution is based on existing RDA replication model. Programming model is exactly the same as RDA today.


Ø  Device applications written today do not need to be updated if the solution is upsized from access to SQL Server.


Ø  There is no conflict detection/resolution.



The setup installs the desktop component required for synchronizing Microsoft Access database with SQL Server Compact Edition database on the device. It also includes a readme file which has the documentation for the solution and a sample application. The readme file can be downloaded separately. The sample application shows how the solution works and how to write applications for this solution. The components installed on the desktop can be used by third party applications to provide data synchronization between Microsoft Access database on the desktop and SQL Server Compact/SQL Mobile database on the device.


  


On a desktop, the following operating systems will be supported:


Ø  Microsoft Windows XP Professional SP2


Ø  Microsoft Windows XP Home Edition SP2


Ø  Microsoft Windows XP Media Center Edition 2005 with Windows XP MCE 2005 Update Rollup 2installed.


Ø  Microsoft Windows XP Tablet PC Edition SP2


Ø  Microsoft Windows Vista (Only Windows Mobile 6.0 devices are supported)


 


On devices, the following operating systems will be supported:


Ø  Windows Mobile 2003 Second Edition


Ø  Windows CE 4.2


Ø  Windows CE 5.0


Ø  Windows Mobile 5.0


Ø  Windows Mobile 6.0


 


The following versions of Microsoft Access will be supported:


Ø  Microsoft Access 2000 SP3 (Microsoft Office 2000)


Ø  Microsoft Access 2002 SP3 (Microsoft Office 2002)


Ø  Microsoft Office Access 2003 SP2 (Microsoft Office 2003)


Ø  Microsoft Office Access 2007


 


This solution will work with all installations for SQL Server Mobile Edition/SQL Server Compact Edition on devices. The sample application provided is supported only on Windows Mobile 5.0 Pocket PC edition.


 


 


For more details on ADS please see the readme


ADS Readme


 


 


Feedback


 


We look forward to you providing us feedback about this solution. You can provide us feedback at


 


SQL Server Mobile Edition/SQL Server Compact Edition MSDN Forum


 


And


 


SQL Server Compact Edition Blog


 


 


Manish Agnihotri, Program Manager, SQL Server 2005 Compact Edition


Please post all SQL Server 2005 Compact Edition  queries at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

Comments (5)

  1. Releases that made there way through to me…. Microsoft SQL Server 2005 Compact Edition Access Database

  2. Bob Li says:

    Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer 为桌面的 Access 数据库和移动设备的 SQL Server Compact Edition 数据库之间进行数据同步提供一种解决方案。

  3. Byteabyte says:

    Como complemento a la nueva versión de SQL CE (la base de datos compacta pensada para usar principalmente

  4. mjkerr says:

    The wizard that is described in the readme isn’t included in the setup file. Is this a mistake, or am I just missing it?

  5. mjkerr says:

    Sorry, I’m dumb. There is no frontend on the desktop.