Today we are very pleased to announce the CTP release of Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. To download the product you can visit the SQL Server Mobile Edition/SQL Server Everywhere Edition product page or click on this link to Access Database Synchronizer reach the download page directly.

 

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

 

The salient features of this solution are summarized below

Ø       Provides a synchronization solution between SQL Server Mobile Edition/SQL Server Everywhere Edition and Microsoft Access. Data conversion should be done while synchronizing the data.

Ø       Synchronization will happen if there is an active ActiveSync connection between the device and the desktop.

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

Ø       Based on existing RDA replication model. Replication setup and programming is exactly the same as RDA today

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

Ø       No conflict detection/resolution is implemented.


The CTP setup installs the desktop component required for synchronizing Microsoft Access database with SQL Server Everywhere Edition database on the device. It also includes a read me file which has the documentation for the solution and a sample application. 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 Everywhere Edition/SQL Mobile database on the device.

  

Access Database Synchronizer Architecture

  

 

 

The operating systems supported for the CTP release are

Ø       Microsoft Windows XP Professional SP2

Ø       Microsoft Windows XP Home Edition SP2

Ø       Microsoft Windows XP Media Center Edition 2002 SP2

Ø       Microsoft Windows XP Media Center Edition 2004 SP2

Ø       Microsoft Windows XP Tablet PC Edition SP2

 

Additionally we plan to support the following operating systems for RTW

Ø       Microsoft Windows XP Media Center Edition 2005

Ø       Microsoft Windows Vista

 

Following versions of Microsoft Access are supported for CTP release

Ø       Microsoft Access 2000 SP3 (Microsoft Office 2000)

Ø       Microsoft Access 2002 SP3 (Microsoft Office 2002)

Ø       Microsoft Office Access 2003 SP2 (Microsoft Office 2003)

 

For RTW, we plan to support Microsoft Office 12 as well.

 

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

 

Note: As of today only SQL Server Mobile Edition is available for devices. SQL Server Everywhere Edition whould be available for devices at time of SQL Server Everywhere Edition RTW whihc is planned for November 2006

 

Feedback

 

We look forward to you providing us feedback about this solution so that we can make it better and as close to your requirements as possible

 

You can provide us feedback at

 

SQL Server Mobile Edition/SQL Server Everywhere Edition MSDN Forum

 

And

 

SQL Server Everywhere Edition Blog - Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS)

 

Know Issues

 

Please visit this section regulary to keep abreast with the known issues which we will post here regularly.

 

 

Manish Agnihotri

Program Manager