Mobilink > Getting started WITHOUT graphical wizard?

[former_SQLA_member1694904]

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

[Breck_Carter]

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

[Breck_Carter]

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.

[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.

[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.

[former_SQLA_member1694904]

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.

[former_SQLA_member1694904]

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?