Sync SQL Server Express 2005 and SQL Server Mobile 2005.

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

Check out System.Data.SqlClient

-Nino

Paul Aspinall wrote:
> 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!
***********************************************
"Paul Aspinall" <> wrote in message
news:%wJkf.137955$ .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
>
>
>
>