Sync SQL Server Express 2005 and SQL Server Mobile 2005.

Sync SQL Server Express 2005 and SQL Server Mobile 2005.

Post by Paul Aspin » Tue, 06 Dec 2005 06:50:51


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
 
 
 

Sync SQL Server Express 2005 and SQL Server Mobile 2005.

Post by Nino Benve » Tue, 06 Dec 2005 13:03:43

Check out System.Data.SqlClient

-Nino

 
 
 

Sync SQL Server Express 2005 and SQL Server Mobile 2005.

Post by Gregory A. » Tue, 06 Dec 2005 22:16:28

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!
***********************************************