The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

Mobilink Sync - I'd like to setup one table in my publication to be "upload-only". I will set the download_ scripts to be {ml_ignore} and only setup ML scripts for the upload_.

This upload-only table will continue to grow in size without download cursors to partition or delete the data. Is there a way to maintain this upload-only table by deleting rows older than 30 days for example (without having those deleted rows upload in the upload_delete sync)?

asked 27 May '16, 10:50

Jason%20MS's gravatar image

Jason MS
1263510
accept rate: 0%

Are you asking about maintatining the table at the remote database, or at the consolidated? I suspect remote, but wanted to double check.

Is your remote database a SQL Anywhere database or an UltraLite database?

Reg

(27 May '16, 10:54) Reg Domaratzki
Replies hidden

Good question. Maintaining the remote which is Ultralite in this instance.

(27 May '16, 11:01) Jason MS

I'm pretty sure that the STOP/START SYNCHRONIZATION DELETE command will do exactly what you want.

http://dcx.sap.com/index.html#sqla170/en/html/8273bd896ce210148dcdb13ce62a80ae.html*loio8273bd896ce210148dcdb13ce62a80ae

I think the sample on the page even demonstrates deleting records older than a month, which isn't exactly 30 days, but is pretty close. :)

Please note the warnings on the page. They are there for a reason.

Warning #1: This command can be useful when making corrections to a remote database, but should be used with caution as it effectively disables MobiLink synchronization. You should only stop deletion logging temporarily.

Warning #2: The way in which UltraLite traces row states is unique. Be sure you understand the implication of deletes and row states.

Reg

permanent link

answered 27 May '16, 11:04

Reg%20Domaratzki's gravatar image

Reg Domaratzki
5.4k33578
accept rate: 40%

edited 27 May '16, 11:06

Perfect! I had never known these STOP/START statements existed for deletes. Thanks!

(27 May '16, 11:14) Jason MS

A good way to think about this feature/statement is that while active it simply prevents the DELETE operations from synchronizing.

So, if you have a downloaded row, and delete it while STOP SYNC DELETE is active, it's deleted from the remote but MobiLink won't hear about the delete.

If you insert then (normally) delete a row on the remote without synchronizing, nothing will be synchronized for that row, of course.

If you insert a row then delete it while STOP SYNC DELETE is active and then synchronize, what happens? The remote will synchronize the insert, only.

(27 May '16, 11:40) Tim McClements
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×295
×145

question asked: 27 May '16, 10:50

question was seen: 235 times

last updated: 27 May '16, 11:40