Contents Index Replicate from the remote database to the consolidated database Restore the data in the database

Introducing SQL Anywhere Studio
  Tutorial: Replicating Data with SQL Remote

Lesson 5: Restore the database and database settings


Once you have completed the tutorial it is important to undo any changes you have made to the sample database. Make sure that the following steps are completed in order to ensure that the settings are reset properly.

Delete the remote user

  1. In the left pane of Sybase Central, click the Users & Groups folder for the sample database.

  2. Right-click the field user, and choose Delete from the popup menu. Click Yes to remove the user from the list.

Delete the publication

  1. Click the Publications folder.

  2. Right-click DepartmentPub in the left pane and choose Delete from the popup menu. Click Yes to confirm the deletion.

Revoke the publishing status from the sample database

  1. Click the Users and Groups folder in the left pane.

  2. Right-click the DBA user in the left pane, and select Revoke Publisher from the popup menu.

Revoking a status while running the database 
The status of a user cannot be modified while the user is running the database. Make sure that the user is idle before revoking or invoking a status.

Restore the original message type settings

  1. Select the SQL Remote Users folder and click the Message Types tab in the right pane.

  2. Right-click the File message type in the right pane and choose Properties.

  3. Delete the publisher address and click OK to restore the settings.

Delete the remote database

  1. In the left pane, select the Adaptive Server Anywhere 9 plug-in.

  2. In the right pane, click the Utilities tab.

  3. In the right pane, double-click Erase Database.

    The Erase Database wizard appears.

  4. Follow the instructions in the wizard.

  5. Enter the name of the database you want to erase or click Browse to search for the database. For example, enter c:\tutorial\field.db. Click Finish to erase the database file.

Notes 

Now that the tutorial is complete, it might be a good idea to delete the tutorial directory (c:\tutorial) in order to save space.


Restore the data in the database

Contents Index Replicate from the remote database to the consolidated database Restore the data in the database