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!
***********************************************
"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:%w********************@fe2.news.blueyonder.co .uk...
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