Synchronising SQL Server 2005 mobile with SQL Server 2005 Express.

Synchronising SQL Server 2005 mobile with SQL Server 2005 Express.

Post by Paul Aspin » Sun, 04 Dec 2005 08:47:42


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).

I believe that I will need to write my own synchronization application, in
order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application when
the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie. do I
just use a connection string from the Desktop machine, but which connects to
the PDA DB??)
- Once I have this connected, I presume I will be able to compare the
data on the desktop machine, against the data on the PDA, and update each
accordingly?

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

Thanks