Sync SQL Server Express 2005 and SQL Server Mobile 2005.

Discussion in 'ActiveSync' started by Paul Aspinall, Dec 4, 2005.

  1. 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
     
    Paul Aspinall, Dec 4, 2005
    #1
    1. Advertisements

  2. Check out System.Data.SqlClient

    -Nino
     
    Nino Benvenuti, Dec 5, 2005
    #2
    1. Advertisements

  3. 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!
    ***********************************************
     
    Cowboy \(Gregory A. Beamer\), Dec 5, 2005
    #3
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.