The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
1263310
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
4.8k33269
accept rate: 41%

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:

×265
×128

question asked: 27 May '16, 10:50

question was seen: 148 times

last updated: 27 May '16, 11:40