SQL Anywhere Mobile - Synchronizing synchronization subscription

Author

Synchronizing synchronization subscription

Eric Verhorstert

2005-07-18, 9:24 am

The values option, address and type are store in the syssync system
table in the remote. I think these values can also be stored in the
consolidated without disturbing the synchonization process. It is
probably not used.

Is it possible to synchronize this table so that the settings can be
changed at consolidated site where the specialist are? The next
synchronization should then be done with the new settings.

Thanks,

Eric

Greg Fenton

2005-07-18, 11:24 am

Eric Verhorstert wrote:
>
> Is it possible to synchronize this table so that the settings can be
> changed at consolidated site where the specialist are? The next
> synchronization should then be done with the new settings.
>

No, those values are "system tables" and as such can only be modified by
DDL statements (e.g. CREATE SYNCHRONIZATION SUBSCRIPTION).

You could put the values you care about into a user table and write an
sp_hook_dbmlsync_* procedure to apply any new values downloaded. Using
EXECUTE IMMEDIATE, you could run the appropriate DDL statement for the
new values.

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/

Reg Domaratzki \(iAnywhere Solutions\)

2005-07-18, 11:24 am

The only way changes can be made to the SYSSYNC table on the remote is
through DDL command such as ALTER SYNCHRONIZATION USER and ALTER
SYNCHRONIZATION SUBSCRIPTION. If you want to manage the contents of the
SYSSYNC table from the consolidated, you'll need to setup a mechanism to
send DDL commands to the remote.

The sp_hook_dbmlsync_sch
ema_upgrade hook on the remote was made for this
purpose. The general idea is that you synchronize a table that contains SQL
commands you want to execute on the remote, and the
sp_hook_dbmlsync_sch
ema_upgrade checks for new row in this table, opens a
cursor and executes all the code in the table, then deletes the table.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Eric Verhorstert" <ontsnapt@hotmail.com> wrote in message
news:42dbbb6c@forums
-2-dub...
> The values option, address and type are store in the syssync system
> table in the remote. I think these values can also be stored in the
> consolidated without disturbing the synchonization process. It is
> probably not used.
>
> Is it possible to synchronize this table so that the settings can be
> changed at consolidated site where the specialist are? The next
> synchronization should then be done with the new settings.
>
> Thanks,
>
> Eric

Sponsored Links