|
Home > Archive > SQL Anywhere Mobile > November 2005 > Acquiring all remote lastsync times from consolidated db
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 |
Acquiring all remote lastsync times from consolidated db
|
|
|
| ASA 8.0.2.4339
From the consolidated database, I need to display a list of
times that each remote db last had a successful replication.
How would I go about querying this information from the
consolidated database?
Thank you
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-11-16, 8:24 pm |
| Are your remote user using UltraLite or ASA? If ASA, is there more than one
publication on the remote?
--
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"
<mark> wrote in message news:437b87df.2802.1681692777@sybase.com...
> ASA 8.0.2.4339
>
> From the consolidated database, I need to display a list of
> times that each remote db last had a successful replication.
> How would I go about querying this information from the
> consolidated database?
>
> Thank you
| |
|
| ASA and one publication.
> Are your remote user using UltraLite or ASA? If ASA, is
> there more than one publication on the remote?
>
> --
> 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"
>
>
> <mark> wrote in message
> 8.0.2.4339 >
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-11-16, 8:24 pm |
| Sorry, I missed that you were using v802 on your first post, so my question
on ASA vs. UL is irrelevant.
This is something you'll need to code yourself in v802. Create your own
table, and n the end_upload connection event, insert/update the row for this
user's upload datetime. In the prepare_for_download
event, update this row
for the user's last successful download time.
So it is extremely easy to do, but you do have to create:
1. 1 table
2. 2 sync scripts
3. 1 stored procedure or an INSERT ON EXISTING UPDATE statement.
If you were using v9, you'd be able to use the last_upload_time and
last_download_time columns of the ml_subscription table to track this
information. These columns were added to support file-based
synchronization, which did not exist in v8.
--
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"
<mark> wrote in message news:437b97ef.2a69.1681692777@sybase.com...[color=darkred]
> ASA and one publication.
>
| |
| Breck Carter [TeamSybase] 2005-11-16, 8:24 pm |
| Wow, I owe you a beer, I would have bet *money*
ml_user.last_download_time existed in V8 :)
On 16 Nov 2005 13:03:37 -0800, "Reg Domaratzki \(iAnywhere
Solutions\)" <FirstName.LastName@ianywhere.com> wrote:
>Sorry, I missed that you were using v802 on your first post, so my question
>on ASA vs. UL is irrelevant.
>
>This is something you'll need to code yourself in v802. Create your own
>table, and n the end_upload connection event, insert/update the row for this
>user's upload datetime. In the prepare_for_download
event, update this row
>for the user's last successful download time.
>
>So it is extremely easy to do, but you do have to create:
>1. 1 table
>2. 2 sync scripts
>3. 1 stored procedure or an INSERT ON EXISTING UPDATE statement.
>
>If you were using v9, you'd be able to use the last_upload_time and
>last_download_time columns of the ml_subscription table to track this
>information. These columns were added to support file-based
>synchronization, which did not exist in v8.
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|