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: 

    isql
-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
go
sp_dboption pubs2, "SELECT INTO", true
go

  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
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1