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