Mobile Syncronisation from desktop data store a breeze

If you are a developer and have worked in mobile space the biggest hurdle would have been ensuring connectivity between desktop DB and the Mobile DB. Some of us used replication to get over the issue and the more daring ones used RDA or something highly customised.

Microsoft has now come up with a very very cool alternative called the Access Database Synchronizer (ADS) that would synchronize the data from your Access database to the Mobile SQL DB via Active Sync.

In official terms:

Microsoft SQL Server 2005 Everywhere Edition 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 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/SQL Mobile database on the device.

Read the official announcement at the team blog here:

http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

And you can download the application from:

http://www.microsoft.com/downloads/details.aspx?FamilyId=B967347A-5DD0-445C-8A9F-AEA3DB9EC4BC&displaylang=en#filelist

Technorati tags: ,

Comments

Post a Comment

Popular posts from this blog

Community Star Discussions and Future

In my continuing discussion with Community Stars across the country, I had a discussion today with Sadashiv. Though he works out of chennai and was here for a short trip, he found time today to discuss the opportunities for Community Star program to improve on. Some of thoughts we generated out of the discussion are as follows: 1. Community Stars are disengaged 'cause of lack of communication with them from MS. Better communication channels need to be developed. 2. Award experience and delivery of the Community Star benefits leave a lot to be desired. 3. Community Stars feel that MS is not laying enough importance on Community Stars and do not value their contributions much. More information needs to flow to CSs. From our end, we are doing the following: 1. Launch an extranet portal exclusively for Community Stars. We will host issue submission on this site. Also, we will share opportunities via this site e.g. beta opportunities 2. Re-launch the Community Star distributi
Read more

Making Vista Search your PST Files

Vista can index a lot of files and for some reason it doesn’t index the MS Outlook files.. maybe it is as Outlook is already doing the same.. in case you still want to search PST from Vista Search here is what you can do: Go to the Control Panel Choose "Indexing Options" Click on the "Advanced" button Click on the "File Types" tab Check the checkbox next to "PST" to include it in the search Select the bullet next to the option "Index Properties and File Contents" Click OK and OK again on the message that appears. This is especially useful for information workers like me who have large PST files and are forced to archive from time to time … indexing the archives would return the information from these forgotten folders as well :) Tip taken from On10.net Technorati tags: Outlook , PST , search
Read more

Technocratical Society

In the past days, I haven’t been blogging. A lot has happened in that time – terrorist attack in Mumbai, MNS lost track, global recession set in and Congress advanced in the country. Here’s an ode to the state of the society as viewed by my nephew, Shantanu Chandra who is in Class XII, Amity International, Gurgaon. The lines below capture the times prevailing and the need for us to drop the “chalta hai” attitude but with caution: This techie world of gizmo and gadget This eerie feeling of incongruous widget Which gives us pleasure and takes pain Along with it makes us insane; Absurdness to such a horizon from where one would never fall And still people call you “Microsoft—…That’s all” A teen like me can’t do without a mobile-call Even though I know it is killing my brain cells, after all; This techie world of gizmo and gadget Makes a non-techie guy weird and hollow The bureaucrat are more concerned about their Sunday meal Than to serve the poor people whose w
Read more