Lesson 4: Set up your MobiLink client databases

MobiLink is designed for synchronization involving a consolidated database server and a large number of mobile databases. In this section, you create two remote databases. For each database you must perform the following tasks:

Create a Product table, which you synchronize with the consolidated database.
Create a synchronization publication, user, and subscription.

In this lesson, you use a SQL Anywhere database for your consolidated database and your MobiLink client. For tutorial purposes your MobiLink client, consolidated database, and MobiLink server all reside on the same computer.

Set up SQL Anywhere databases

To set up the MobiLink client databases, you create Product tables for each database. The Product table corresponds to the Product table on the consolidated database but does not include the last_modified column. The MobiLink server uses SQL-based scripts to synchronize product quantities.

You create a synchronization user, publication, and subscription on the client database after creating the tables. Publications identify the tables and columns on your remote database that you want synchronized. These tables and columns are called articles. A synchronization subscription subscribes a MobiLink user to a publication.

To set up your MobiLink client databases

Create your MobiLink client databases using the dbinit command line utility.

Run the following command to create the remote1 database:
dbinit -p 4096 remote1
Run the following command to create the remote2 database:
dbinit -p 4096 remote2
The -p option defines a 4K page size shown to increase performance for many environments.
Start your MobiLink client database using the dbeng12 command line utility.

Run the following command to start the remote1 database:
dbeng12 remote1
Run the following command to start the remote2 database:
dbeng12 remote2
Connect to the remote1 database using Interactive SQL.

Run the following command:
dbisql -c "server=remote1;uid=DBA;pwd=sql"

Create the Product table for the remote1 database.

Run the following SQL script in Interactive SQL:

CREATE TABLE Product (
    name            VARCHAR(128) NOT NULL PRIMARY KEY,
    quantity        INTEGER
)

Create your MobiLink synchronization user, publication, and subscription for the remote1 database.

Run the following SQL script in Interactive SQL:

CREATE PUBLICATION pub_1 (TABLE Product);
CREATE SYNCHRONIZATION USER user_1;
CREATE SYNCHRONIZATION SUBSCRIPTION TO pub_1 FOR user_1
  TYPE TCPIP ADDRESS 'host=localhost' OPTION scriptversion='ver1';

Close Interactive SQL.
Connect to the remote2 database using Interactive SQL.

Run the following command:
dbisql -c "server=remote2;uid=DBA;pwd=sql"

Create the Product table for the remote2 database.

Run the following SQL script in Interactive SQL:

CREATE TABLE Product (
    name            VARCHAR(128) NOT NULL PRIMARY KEY,
    quantity        INTEGER
)

Create your MobiLink synchronization user, publication, and subscription for the remote2 database.

Run the following SQL script in Interactive SQL:

CREATE PUBLICATION pub_2 (TABLE Product);
CREATE SYNCHRONIZATION USER user_2;
CREATE SYNCHRONIZATION SUBSCRIPTION TO pub_2 FOR user_2
  TYPE TCPIP ADDRESS 'host=localhost' OPTION scriptversion='ver1';

Close Interactive SQL.