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 - Server-Initiated Synchronization » Server-initiated synchronization tutorials » Tutorial: Configuring server-initiated synchronization using light weight polling

 

Lesson 1: Setting up the consolidated database

In this lesson, you create a consolidated database named SIS_CarDealer_LP_DBLSN_CONDB with the scripts required for synchronization using the dbinit utility. You then use the SQL Anywhere 16 driver to define an ODBC data source for the SIS_CarDealer_LP_DBLSN_CONDB database.

Prerequisites

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Configuring server-initiated synchronization using light weight polling.

 Task

  1. Create a new working directory to store the consolidated database.

    This tutorial assumes c:\MLsis as the working directory.

  2. Create the SQL Anywhere consolidated database using the dbinit utility, and set the DBA user ID to DBA and password to sql.

    Change to the c:\MLsis directory and run the following command: 

    dbinit -dba DBA,sql SIS_CarDealer_LP_DBLSN_CONDB

  3. Start the consolidated database.

    Run the following command:

    dbsrv16 SIS_CarDealer_LP_DBLSN_CONDB

  4. Click Start » Programs » SQL Anywhere 16 » Administration Tools » ODBC Data Source Administrator.

  5. Click the User DSN tab, and then click Add.

  6. In the Create New Data Source window, click SQL Anywhere 16 and click Finish.

  7. Perform the following tasks in the ODBC Configuration For SQL Anywhere window:

    1. Click the ODBC tab.

    2. In the Data source name field, type SIS_CarDealer_LP_DBLSN_CONDB.

    3. Click the Login tab.

    4. In the User ID field, type DBA.

    5. In the Password field, type sql.

    6. From the Action dropdown list, choose Connect to a running database on this computer.

    7. In the Server name field, type SIS_CarDealer_LP_DBLSN_CONDB.

    8. Click OK.

  8. Close the ODBC data source administrator.

    Click OK on the ODBC Data Source Administrator window.

Results

The consolidated database is created and an ODBC data source is defined.

Next

Proceed to Lesson 2: Generating a database schema.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0