Sync SQL Server Express 2005 and SQL Server Mobile 2005.

  • Thread starter Thread starter Paul Aspinall
  • Start date Start date
P

Paul Aspinall

Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server 2005
(mobile and express).

How can I connect to the Desktop DB, from the PDA, in order to check if I
should transfer data, in my manual syncronization routine.

Any examples of this being done, or details of best practices for this would
be much appreciated

Thanks
 
The most common method, at least from my experience, is to timestamp the
tables that have to be synced. You can then write an "update" routine to
sync the information that is newer than the last sync point. This can be uni
or bi directional.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***********************************************
Think Outside the Box!
***********************************************
 
Back
Top