SQL Anywhere Mobile - synchronize two way

Author

synchronize two way

Ron van der Wiele

2005-05-07, 11:24 am

I want to synchronize data between my pda (remote data) and my desktop
(consolidated/server data).

What works is synchronize from the pda to the consolidated database.
What does not work is synchronize from the consolidated/server to the
remote.

The consolidated/server database now and then gets extra data added and that
data must also be synchronized to the pda.
In fact this is 'two way' synchronizing.

I thought also that first the remote data gets synchronized with the
consolidated/server
data and after that de server gets synchronized to the remote (thus adding
the extra data from the server).

Further I made a publication on both the remote and the server site.
Sbmlsrv8 runs on the consolidated database site and dbmlsync runs on the
remote site.
The version is 8.02.4322

Am i forgetting something or doing something completely wrong?

Ron

Greg Fenton

2005-05-09, 3:24 am

Ron van der Wiele wrote:
>
> I thought also that first the remote data gets synchronized with the
> consolidated/server
> data and after that de server gets synchronized to the remote (thus adding
> the extra data from the server).
>

Yes, the first phase in synchronization is the Upload Phase, where all
modified data in the publication is uploaded from the remote to the
consolidated (well, to the ML server which decides what to do with the
uploaded data...typically it applies it to the consolidated).

The second phase of the synchronization (after the Upload Phase is
committed) is the Download Phase. In this phase, for each table in the
remote's publication a download_cursor event is called, running whatever
synchronization script you have associated with it.

> Further I made a publication on both the remote and the server site.

You do *not* need a publication in the consolidated. It won't hurt to
have it, but the ML server will not use it at all (and just leads to
confusion). The publication exists in the *remote* to identify the
tables/columns that are to synchronized.

Note: it is the *remote* publication that identifies the events that are
run during the synchronization process.

>
> Am i forgetting something or doing something completely wrong?
>

Try starting dbmlsrv8 with the options "-v+ -o ml.out" and check what
events are firing during the synchronization and see what rows are
uploaded (during the first phase) and downloaded (second phase). If you
are still not sure why rows are not being downloaded, try posting the
log file so we can see.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

R. van der Wiele

2005-05-10, 9:23 am

Ok, thanks, I shall investigate (the 'logfile' had already been made with
the proposed parameters), if I can't see the problem I post/paste the file.
Ron

<snip>

> Try starting dbmlsrv8 with the options "-v+ -o ml.out" and check what
> events are firing during the synchronization and see what rows are
> uploaded (during the first phase) and downloaded (second phase). If you
> are still not sure why rows are not being downloaded, try posting the
> log file so we can see.
> greg.fenton

Sponsored Links