Does SQL Remote play nice with MobiLink?

[Breck_Carter]

When a SQL Anywhere 11.0.1 database is participating as the middle level tier in a three-level replication/synchronization structure, and synchronization with the top level is being performed via MobiLink for upload and Replication Server for download, and replication with the bottom level is being performed by SQL Remote, do the two clients dbremote.exe and dbmlsync.exe play nice with respect to the delete_old_logs option on the middle level database?

In other words, will they each preserve log files needed by the other?

[VolkerBarth]

Nice tags, BTW:)

[Former Member · Accepted solution]

Yes. Logs are only deleted when no subscription (dbremote nor dbmlsync) nor dbltm requires the log.

[VolkerBarth]

Well, I had used v8 in a three-tier setup (with MobiLink against a MS SQL Server and with SQL Remote against ASA 8 remotes) for years. Option delete_old_logs was (and is) set to "delay". Never had issues with this option. Note that in our case, the ML log truncation point was always higher than the SQL Remote truncation offset so in practise it was SQL Remote's part to delete old logs.

Since some time, the MS SQL consolidated could be omitted, and now the system is a simple two-tier setup. Much easier when it comes to schema updates:)