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

SAP Sybase SQL Anywhere 16.0 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Using direct row handling

 

Lesson 7: Setting up your MobiLink client database

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.

Prerequisites

This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up a text file data source.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Using direct row handling.

Context and remarks

To set up the MobiLink client database, create the RemoteOrders and OrderComments tables. The RemoteOrders table corresponds to the RemoteOrders table on the consolidated database. The MobiLink server uses SQL-based scripts to synchronize remote orders. The OrderComments table is only used on client databases. The MobiLink server processes the OrderComments tables using special events.

After creating the tables, you create a synchronization user, publication, and subscription on the client database. 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.

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

    Run the following command:

    dbinit -i -k -dba DBA,sql remote1

    The -i and -k options omit jConnect support and Watcom SQL compatibility views, respectively.

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

    Run the following command:

    dbsrv16 remote1
  3. Run the following command to connect to your MobiLink client database from Interactive SQL:

    dbisql -c "SERVER=remote1;UID=DBA;PWD=sql"
  4. Create the RemoteOrders table by executing the following SQL statement in Interactive SQL:

    CREATE TABLE RemoteOrders (
        order_id           INTEGER NOT NULL,
        product_id         INTEGER NOT NULL,
        quantity           INTEGER,
        order_status       VARCHAR(10) DEFAULT 'new',
        PRIMARY KEY(order_id)
    );
  5. Create the OrderComments table by executing the following statement in Interactive SQL:

    CREATE TABLE OrderComments (
        comment_id         INTEGER NOT NULL,
        order_id           INTEGER NOT NULL,
        order_comment      VARCHAR(255),
        PRIMARY KEY(comment_id),
        FOREIGN KEY(order_id) REFERENCES RemoteOrders(order_id)
    );
  6. Execute the following statements in Interactive SQL to create your MobiLink synchronization user, publication, and subscription:

    CREATE SYNCHRONIZATION USER ml_sales1;
    CREATE PUBLICATION order_publ (TABLE RemoteOrders, TABLE OrderComments);
    CREATE SYNCHRONIZATION SUBSCRIPTION TO order_publ FOR ml_sales1
     TYPE TCPIP ADDRESS 'host=localhost';
    Note

    You specify how to connect to the MobiLink server using the TYPE and ADDRESS clauses in the CREATE SYNCHRONIZATION SUBSCRIPTION statement.

    You can use publications to determine what data is synchronized. In this case, you specify the entire RemoteOrders and OrderComments tables.

Results

The remote SQL Anywhere database is created.

Next

Proceed to Lesson 8: Synchronizing.

 See also