SQL Anywhere Mobile - Creating table shadows

Author

Creating table shadows

Mad Vlad

2005-11-24, 11:23 am

Following on posts from 18/11/2005, about deletes in Consolidated not
getting synchronized in remotes - I got it sorted now by using a
TABLENAME_shadow table consisting of primary key fields and last_modified
for each published table. Dowload_delete_curso
rs for each one are SELECT
keyfield1 (keyfield2...) FROM shadowtable WHERE last_modified >= ?

However, it was quite painful to do it for a number of tables that I need. I
did learn a lot about it all, but i was wondering - if I had to do it again,
is there some built-in functionality that can generate SQL code for shadow
tables and the download_delete_curs
ors?

Thanks

Reg Domaratzki $iAnywhere Solutions$

2005-11-24, 1:23 pm

In the Jasper release, we'll have the MobiLink Manager plug-in for Sybase
Central (the name may yet change, or I might be using the wrong name right
now) which will automate the task of creating shadow tables for deletes
amongst many other things. For now, your best bet would be to write a
stored procedure that looped through the rows in SYS.SYSCOLUMNS for a given
table and automatically created a shadow table, delete trigger and
download_delete_curs
or for you.

--
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 filter to "Display ALL platforms IN ALL MONTHS"

"Mad Vlad" <vlad@NOSPAMpcr.ltd.uk> wrote in message
news:4385eb9c$1@foru
ms-2-dub...
> Following on posts from 18/11/2005, about deletes in Consolidated not
> getting synchronized in remotes - I got it sorted now by using a
> TABLENAME_shadow table consisting of primary key fields and last_modified
> for each published table. Dowload_delete_curso
rs for each one are SELECT
> keyfield1 (keyfield2...) FROM shadowtable WHERE last_modified >= ?
>
> However, it was quite painful to do it for a number of tables that I need.
I
> did learn a lot about it all, but i was wondering - if I had to do it
again,
> is there some built-in functionality that can generate SQL code for shadow
> tables and the download_delete_curs
ors?
>
> Thanks
>
>

Mad Vlad

2005-11-25, 9:24 am

Thanx.

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:43860a14$1@foru
ms-2-dub...
> In the Jasper release, we'll have the MobiLink Manager plug-in for Sybase
> Central (the name may yet change, or I might be using the wrong name right
> now) which will automate the task of creating shadow tables for deletes
> amongst many other things. For now, your best bet would be to write a
> stored procedure that looped through the rows in SYS.SYSCOLUMNS for a
> given
> table and automatically created a shadow table, delete trigger and
> download_delete_curs
or for you.
>
> --
> 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 filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "Mad Vlad" <vlad@NOSPAMpcr.ltd.uk> wrote in message
> news:4385eb9c$1@foru
ms-2-dub...
> I
> again,
>
>

Sponsored Links