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

SQL Anywhere 12.0.1 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Using MobiLink with an Adaptive Server Enterprise consolidated database


Lesson 2: Preparing the consolidated database

This lesson assumes you have completed all preceding lessons. See Lesson 1: Designing the schemas.

In this lesson, you increase the size of the consolidated database for MobiLink synchronization and create unique primary keys.

MobiLink needs to add system tables and other objects to the pubs2 database for synchronization. When you add these objects, the size of the pubs2 database must be increased.

 Prepare the consolidated database
  1. Connect to the pubs2 database as sa, using iSQL in Adaptive Server Enterprise. At a command prompt, run the following command, all on one line:

    -U sa
    -P your-password-for-sa-account
    -D pubs2

    If you are accessing Adaptive Server Enterprise remotely, use the -S option to specify the server name.

  2. To have proper permission for increasing the size of a database, you must access the master database. Run the following command in iSQL:

    use master
    sp_dboption pubs2, "SELECT INTO", true
  3. In Adaptive Server Enterprise, a database is stored on a disk or a portion of a disk. To increase the size of the pubs2 database, execute the following statement (you must specify the disk where pubs2 is stored):

    ALTER DATABASE pubs2 ON disk-name = 33
  4. Proceed to Lesson 3: Adding unique keys.

 See also