Cleaning up

Regenerate the pubs2 database and remove all tutorial materials from your computer.

Prerequisites

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

This lesson assumes you have the roles and privileges listed in the Permissions and privileges section at the start of this tutorial: Tutorial: Using MobiLink with an Adaptive Server Enterprise consolidated database.

Task

Regenerate the pubs2 database.

To run the script that installs the pubs2 database, run the following command:

isql
-U sa
-P your-password-for-sa-account
-i %SYBASE%\%SYBASE_ASE%\scripts\instpbs2

If you are accessing Adaptive Server Enterprise remotely, use the -S option to specify the server name. You also have to copy the instpbs2 file locally onto your computer. The -i option needs to updated so that the new location of the instpbs2 file is specified.

Delete the synchronization model.
1. Start Sybase Central.
2. Double-click MobiLink 16 in the right pane.
  
  The sync_ase model appears.
3. Right-click sync_ase and choose Delete.
Erase the remote database by using the dberase utility.

Run the following command:
dberase sync_ase\remote\sync_ase_remote.db

Results

The pubs2 database is regenerated and all tutorial materials are removed from your computer.

Next

None.

Discuss this page in DocCommentXchange.