Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » MobiLink - Server-Initiated Synchronization » Server-initiated synchronization tutorials » Tutorial: Server-initiated synchronization using gateways

 

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