Whether you are designing a new database or preparing an existing one to be used as a MobiLink consolidated database, you must install the MobiLink system tables in that database. MobiLink setup scripts for SQL Anywhere 10, Adaptive Server Enterprise, Oracle 8 and 9, Microsoft SQL Server, and IBM DB2 databases are located in the MobiLink\setup directory of your SQL Anywhere installation. (Setup scripts are not required for Adaptive Server Anywhere 9, but are required for SQL Anywhere 10 consolidated databases.)
MobiLink system tables store information for MobiLink users, tables, scripts, and script versions in the consolidated database. You will probably not directly access these tables, but you alter them when you perform actions such as adding synchronization scripts.
To carry out synchronization, the MobiLink synchronization server needs an ODBC connection to the consolidated database. You must have an ODBC driver for your server and you must create an ODBC data source for the database on the machine on which your MobiLink synchronization server is running. For a list of supported drivers, see Recommended ODBC Drivers for MobiLink.
There are two types of events that occur during synchronization and for which you need to write synchronization scripts:
Connection events that perform global tasks required during every synchronization
Table events that are associated with a specific table and perform tasks related to modifying data in that table
