Re: Replicated DB and synchronize with PPC with active Sync

From: Doug T. (dat_at_dat.com)
Date: 02/22/04

  • Next message: Michael \(michka\) Kaplan [MS]: "Re: An account of setting up a replicated system" 
    Date: Sat, 21 Feb 2004 20:49:25 -0600

    SQL Server will not be used for this consumer application, where I'll have a
    maximum of 2-3 desktops and 2-3 handhelds.

    There was no problem in converting s_GUIDs into string and back: strings for
    the handhelds and 16-bit bytes for the desktops.
    You will need to trigger an application before and after ActiveSync to run
    your converison application.
    There is complete control over the schema columns. Just act on them like
    you would any other table. Insert, Delete, Update work.

    Anyway, after playing around this morning, I have created a schema, and
    mechanism to synchronize without JRO.

    Doug

    This posting is provided "IS AS" with complete warranties, and confers all
    rights.

    "Michael (michka) Kaplan [MS]" <michkap@online.microsoft.com> wrote in
    message news:eysRUIL%23DHA.3816@TK2MSFTNGP09.phx.gbl...
    > It is not realistic to try and mimic the desktop replication schema onto a
    > CE device (especially since you cannot change the system columns in the
    > desktop db and thus there is no purpose to duplicating them).
    >
    > You may want to look into SQL Server -- Windows CE edition.
    >
    >
    > --
    > MichKa [MS]
    > NLS Collation/Locale/Keyboard Development
    > Globalization Infrastructure and Font Technologies
    >
    > This posting is provided "AS IS" with
    > no warranties, and confers no rights.
    >
    >
    >
    > "Doug T." <dat@dat.com> wrote in message
    > news:u%23xGKkc9DHA.1804@TK2MSFTNGP12.phx.gbl...
    > > Same problem as I described yesterday also.
    > > The option I am trying now is to:
    > > Convert local Access DB with S_GUID from 16-bit byte to string.
    > > Active sync - synchronize Pocket PC and Access DB.
    > > When complete, convert Access DB from string to s_GUID.
    > >
    > > This will require a system of producing string s_GUID's on the Pocket
    PC.
    > >
    > > Would be much easier if there was native support of s_GUID type in
    Pocket
    > > PC.
    > >
    > > I am not sure what will happen to the OLE Object - s_Lineage.
    > >
    > > Doug
    > >
    > >
    > > "***" <hogeweide@yahoo.com> wrote in message
    > > news:953901c3ea37$f5e39720$a601280a@phx.gbl...
    > > > I'm trying to synchronize an replicated Access 2000 DB
    > > > with my Pocket PC (MS mobile 2003). The problem is already
    > > > when the DB is copied to (and converted) the s_Guid is not
    > > > copied or converted. The DB works on the pocket PC and I
    > > > can also synchronize with a non replaicated DB but not
    > > > with my replicated DB (even if it is the master) because
    > > > of the inserted colums at the original replica (like the
    > > > s_GUID).
    > > >
    > > > Anybody had the same problem or a solution?
    > >
    > >
    >
    >

  • Next message: Michael \(michka\) Kaplan [MS]: "Re: An account of setting up a replicated system"
    Loading