The forum will be down for maintenance at some point between Friday, September 25, 2020 at 5pm PDT and Sunday, September 27, 2020 at 11:59 PDT. Downtime is unknown but will be minimized.

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, 03:37

saurabhnanda's gravatar image

saurabhnanda
46129
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, 09:35

Breck%20Carter's gravatar image

Breck Carter
30.8k496680992
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, 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, 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, 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, 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, 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:

×353

question asked: 08 Sep, 03:37

question was seen: 84 times

last updated: 09 Sep, 03:12