Home > Archive > SQL Anywhere Mobile > October 2005 > Uploading data on first synchronization









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Uploading data on first synchronization
Julien DAZA

2005-10-31, 7:24 am

Hello !

How can I upload rows from the remote database, on first
synchronization ?

I want to synchronize 2 databases, with Mobilink 8.0.3.5002.
Some tables on the remote database contains data I'd like to
upload on first synchronization.
Is there a way to do this with Mobilink, or do I have to to
insert rows manually in the consolidated database before
first synchronization ?

Thanks in advance

Julien DAZA
Greg Fenton

2005-10-31, 7:24 am

Julien DAZA wrote:
>
> How can I upload rows from the remote database, on first
> synchronization ?
>


The way that dbmlsync identifies rows needing to be uploaded is by
scanning the transaction log. For the initial synch, it will upload any
rows that have been modified since the creation of the publication in
the remote database. If you create the publication and immediately
synchronize, then there will be nothing to upload.

The good news is that there is a whitepaper that describes the process
you are looking for:

http://www.ianywhere.com/whitepaper...lidated_db.html

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





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com