Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Is there any tutorial/document that describes the process of getting started with a mobilink installation WITHOUT using the graphical wizard that is referred to in Tutorial: Using MobiLink with a SQL Anywhere consolidated database

asked 08 Sep '20, 03:37

saurabhnanda's gravatar image

saurabhnanda
46121219
accept rate: 0%


Chapter 7 of SQL Anywhere Studio 9 Developer's Guide pre-dates the wizard, so all it shows are SQL statements for setting up MobiLink synchronization...

Chapter 7 Synchronizing . . . . . . . . . . . . . . . . . . . . . 211
7.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211
7.2 How MobiLink Works . . . . . . . . . . . . . . . . . . . . . . . . . . . . 212
7.3 The MobiLink ASA Client . . . . . . . . . . . . . . . . . . . . . . . . . . 216
7.4 MobiLink Client Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . 217
7.4.1 CREATE PUBLICATION . . . . . . . . . . . . . . . . . . . . . . . 217
7.4.2 CREATE SYNCHRONIZATION USER . . . . . . . . . . . . . . . 219
7.4.3 CREATE SYNCHRONIZATION SUBSCRIPTION . . . . . . . . . 220
7.4.4 The DBMLSYNC Command Line . . . . . . . . . . . . . . . . . . 221
7.4.5 SYSSYNC and Publication Defaults . . . . . . . . . . . . . . . . . 226
7.5 The MobiLink Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 228
7.6 MobiLink Server Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . 229
7.6.1 Connection-Level Scripts . . . . . . . . . . . . . . . . . . . . . . . 229
7.6.2 Session-Level Scripts . . . . . . . . . . . . . . . . . . . . . . . . . 230
7.6.3 Table-Level Scripts. . . . . . . . . . . . . . . . . . . . . . . . . . . 232
7.6.4 Row-Level Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . 233
7.6.4.1 Handling Uploaded Inserts. . . . . . . . . . . . . . . . . . . 233
7.6.4.2 Handling Uploaded Updates. . . . . . . . . . . . . . . . . . 234
7.6.4.3 Handling Uploaded Deletes . . . . . . . . . . . . . . . . . . 235
7.6.4.4 Handling Upload Conflicts . . . . . . . . . . . . . . . . . . 236
7.6.4.5 Handling Upload Errors . . . . . . . . . . . . . . . . . . . . 240
7.6.4.6 Downloading Inserts and Updates . . . . . . . . . . . . . . . 243
7.6.4.7 Downloading Deletes . . . . . . . . . . . . . . . . . . . . . 246
7.6.4.8 Handling Download Errors . . . . . . . . . . . . . . . . . . 249
7.7 The MobiLink System Tables . . . . . . . . . . . . . . . . . . . . . . . . 254
7.8 MobiLink Monitor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 258
7.9 Chapter Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 260
permanent link

answered 08 Sep '20, 09:35

Breck%20Carter's gravatar image

Breck Carter
32.5k5417271050
accept rate: 20%

If you are setting up synchronization for a large number of tables, get it working for a few tables (one or two), and then write some SQL code to generate the simple download cursor and upload insert/update/delete scripts. Save all the code in large *.sql scripts and maintain those scripts directly; don't try to re-use the generation scripts.

(08 Sep '20, 09:39) Breck Carter

A few of your MobiLink scripts may have to handle complex requirements (e.g., conflicts, schema differences, etc). Don't try to automate the generation of those scripts unless there are a lot of similar ones, write custom code instead.

(08 Sep '20, 09:49) Breck Carter

Create and maintain a separate local development environment of one consolidated database and at least two remote databases, and use that for testing all new and modified MobiLink scripts.

(08 Sep '20, 09:50) Breck Carter

Breck, do you have an e-book of this (on leanpub, perhaps)? I'm based out of India, and will be unable to wait for this to be shipped and delivered from US.

(09 Sep '20, 02:42) saurabhnanda

I've got a Mobilink setup working (via the wizard), which results in the following SQL files - https://gist.github.com/saurabhnanda/4eea0fb6ad24691606355c748572770b - one for the consolidated DB and the other for the remote DB. If I start from scratch without using the mobilink wizard, how do I create the many ml_* tables that the wizard creates? And how do I get access to the ml_* procs that are used all over these scripts?

(09 Sep '20, 03:12) saurabhnanda
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:

×371

question asked: 08 Sep '20, 03:37

question was seen: 946 times

last updated: 09 Sep '20, 03:12