Introducing SQL Anywhere Studio
Tutorial: Replicating Data with SQL Remote
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
In the left pane of Sybase Central, click the Users & Groups folder for the sample database.
Right-click the field user, and choose Delete from the popup menu. Click Yes to remove the user from the list.
Delete the publication
Click the Publications folder.
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
Click the Users and Groups folder in the left pane.
Right-click the DBA user in the left pane, and select Revoke Publisher from the popup menu.
Revoking a status while running the databaseThe 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
Select the SQL Remote Users folder and click the Message Types tab in the right pane.
Right-click the File message type in the right pane and choose Properties.
Delete the publisher address and click OK to restore the settings.
Delete the remote database
In the left pane, select the Adaptive Server Anywhere 9 plug-in.
In the right pane, click the Utilities tab.
In the right pane, double-click Erase Database.
The Erase Database wizard appears.
Follow the instructions in the wizard.
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.
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