Re: Replication between sql2k, MSDE and ce

From: Seanna (seanna_gisele_at_yahoo.ca)
Date: 11/22/04

  • Next message: Khalid Rahaman: "Just getting Started" 
    Date: Mon, 22 Nov 2004 15:18:26 -0800

    Hi, Debra:

    Very interesting test. I changed the same column of the same row on the PDA,
    synchronized, then changed the same through MSDE, and synchronized, raised a
    publisher conflict on that record, and the change from the PDA was chosen as
    the conflict winner, and showed up in the MSDE tables.

    Configuration:

    On the server:

    Sql Server 2k with Service Pack 3 (I believe)

    On the PDA (hp iPAQ):

    App is developed using VB.NET

    Sql Server CE 2.0

    On the local machine:

    MSDE v8.00.760 with Service Pack 4 (I believe)

    Our replication (publishers) configuration is standard. We enable them for
    SQL CE devices, but otherwise, we leave the default settings. The whole
    table is replicated for both PDA and MSDE; we don't filter on columns or
    rows.

    Any help you could provide with pinpointing how to "wake up" the MSDE
    synchronization would be greatly appreciated; we have a work around that
    involves connecting only online with MSDE and directly to the server,
    obviously this isn't ideal for our remote users.

    Thanks!

    Seanna

    ""Debra Dove [MS]"" <ddove@online.microsoft.com> wrote in message
    news:nrk$70N0EHA.3152@cpmsftngxa10.phx.gbl...
    > Question,
    >
    > if you sync changes from the PDA to the server, then you also make a
    change
    > at the server for the same filter value, then you sync the MSDE database
    to
    > the server, do you get the PDA changes, the changes made at the server
    > directly, both or neither?
    >
    > It seems from your original description that the changes from the PDA to
    > the server are being marked in such a way that the MSDE subscriber thinks
    > it already has them when synching to the server, even though it doersn't.
    >
    > Is it possible for you to send me a detailed description of your
    > configuration? I am wondering if this is occuring only because of cascaded
    > filters clauses or something, but doesn't occur in other configurations.
    >

  • Next message: Khalid Rahaman: "Just getting Started"

    Relevant Pages

    • Re: SQL Mobile and MSDE
      ... The only fully supported Oracle synchronization solution I know of is use to Oracle Lite on the device. ... with RDA and sync the laptop to the server. ... I' am trying to determine if i should use CF 1.x with SQL CE 2.0 and MSDE for a new application or CF 2.0 with SQL Mobile and MSDE. ... I was told that the solution MUST use MSDE since the client already has an application using this but with laptop computers. ...
      (microsoft.public.dotnet.framework.compactframework)
    • Re: Merge Repliaction between sql server CE and SQL 2k without del
      ... Make sure you are not actually deleting records from the subscriber. ... SQL Server Replication ... > the records from the PDA. ... >> I'm not sure why you say synchronization twice would be ...
      (microsoft.public.sqlserver.replication)
    • Re: Replication between sql2k, MSDE and ce
      ... MSDE is not picking up the generations that are sent by the PDA ... sp_mergedummyupdate on the row in question means that MSDE does pick it up. ... I have a sqlce database and MSDE database subscribing to the same publisher ... (sql server 2k sp 3a). ...
      (microsoft.public.sqlserver.ce)
    • Re: Merge Repliaction between sql server CE and SQL 2k without del
      ... from the server when I synchronized the PDA with the server after deleting ... the records from the PDA. ... "Paul Ibison" wrote: ... > I'm not sure why you say synchronization twice would be ...
      (microsoft.public.sqlserver.replication)
    • Re: Cant synchronise my inbox, calendar and inbox
      ... AS configuration and changed it to sync from a server instead on the PC. ... Check on Sync options whether the 'enable synchronization with server' was ... > pops up on the PDA: ...
      (microsoft.public.pocketpc.activesync)