Sync SQL Server Express 2005 and SQL Server Mobile 2005.

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
 
C

Cowboy \(Gregory A. Beamer\)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronising SQL Server 2005 mobile with SQL Server 2005 Express 7
Using SMO for SQL Server 2008 Express AND SQL Server 2005 Express 6
Convert Access -> SQL Server 2005 1
SQL Server Mobile Edition & C# on the Desktop 2
Install SQL Server 2005 Express With ClickOnce? 1
SQL Server 2000 9
from Express to sql Server 2005 2
Sql Server Express won't let me connect 8

Top