Lesson 7: 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 remote1
  2. Start your MobiLink client database using the dbeng12 command line utility.

    Run the following command:

    dbeng12 remote1
  3. Connect to your MobiLink client database using Interactive SQL.

    Run the following command:

    dbisql -c "server=remote1;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 car_dealer_pub (table Dealer);
    CREATE SYNCHRONIZATION USER sis_user1;
    CREATE SYNCHRONIZATION SUBSCRIPTION 
        TO car_dealer_pub 
        FOR sis_user1 
        OPTION scriptversion='sis_ver1';
    COMMIT;
 See also