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

SQL Anywhere 11.0.1 » MobiLink - Server-Initiated Synchronization » Server-initiated synchronization tutorials » Tutorial: Server-initiated synchronization using gateways

 

Lesson 1: Set up the consolidated database

In this lesson, you create a consolidated database with the scripts required for synchronization using the dbinit utility.

To create and start a new SQL Anywhere consolidated database
  1. Create the SQL Anywhere consolidated database.

    At the command prompt, use the dbinit utility and specify a file name and path for the database. For example, run the command:

    dbinit c:\MLsis\MLconsolidated.db
  2. Start the consolidated database.

    dbeng11 c:\MLsis\MLconsolidated.db

Use the SQL Anywhere 11 driver to define an ODBC data source for the database.

To define an ODBC data source for the consolidated database
  1. Choose Start » Programs » SQL Anywhere 11 » ODBC Administrator.

  2. Click the User DSN tab, and click Add.

  3. On the Name list, click SQL Anywhere 11. Click Finish.

  4. In the ODBC Configuration For SQL Anywhere 11 window, do the following:

    1. Click the ODBC tab.

    2. In the Data Source Name field, type sis_cons.

    3. Click the Login tab.

    4. In the User ID field, type DBA.

    5. In the Password field, type sql.

    6. Click the Database tab.

    7. In the Server Name field, type MLconsolidated.

    8. In the Database File field, type c:\MLsis\MLconsolidated.db.

    9. Click OK.

  5. Click OK.

See also