Preparing consolidated databases – PB Docs 125

Preparing consolidated databases

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. SQL Anywhere
provides setup scripts for Sybase Adaptive Server Enterprise, Oracle,
Microsoft SQL Server, and IBM DB2.
A setup script is not required for SQL Anywhere 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.

ODBC connections and drivers

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
.

Writing synchronization scripts

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


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x