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

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

    Run the following command:

    dbinit SIS_CarDealer_LP_DBLSN_REM

  2. Start your MobiLink client database using the dbeng12 command line utility.

    Run the following command:

    dbeng12 SIS_CarDealer_LP_DBLSN_REM

  3. 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"

  4. 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;

  5. 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;
 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0