Lesson 5: Set up a remote database

In this lesson, you create a SQL Anywhere remote database, create a synchronization publication, a user, and a subscription. You also create the command file for the MobiLink Listener, and then start the MobiLink Listener.

♦ To set up your MobiLink client database

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

Run the following command:
dbinit SIS_CarDealer_LP_DBLSN_REM
Start your MobiLink client database using the dbeng12 command line utility.

Run the following command:
dbeng12 SIS_CarDealer_LP_DBLSN_REM
Connect to your MobiLink client database using Interactive SQL.

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

Create the Dealer table.

Run the following SQL script in Interactive SQL:

CREATE TABLE Dealer (
    name           VARCHAR(10) NOT NULL PRIMARY KEY,
    rating         VARCHAR(5),
    last_modified  TIMESTAMP DEFAULT TIMESTAMP
)
COMMIT;

Create your MobiLink synchronization user, publication, and subscription.

Run the following SQL script in Interactive SQL:

CREATE PUBLICATION CarDealer(TABLE DEALER WHERE 0=1)
CREATE SYNCHRONIZATION USER test_mluser OPTION ScriptVersion='CarDealer'
CREATE SYNCHRONIZATION SUBSCRIPTION TO CarDealer FOR test_mluser
SET OPTION public.ml_remote_id = remote_id;
COMMIT;

Lesson 5: Set up a remote database

♦ To set up your MobiLink client database

See also