Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Remote » Managing SQL Remote systems » Remote database extraction

 

Extracting a remote database automatically

Extract a consolidated database and reload the schema and data into a new database. No interim copy of the data is created on disk.

Prerequisites

You must have the EXECUTE ANY PROCEDURE and SELECT ANY TABLE privileges. The SELECT ANY TABLE privilege comes with the SYS_REPLICATION_ADMIN_ROLE role.

Context and remarks

For information about extracting remote databases to a reload file, see Remote database extraction.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the consolidated database.

  2. Click Tools >> SQL Anywhere 16 » Extract Database.

  3. Choose the consolidated database to connect to and extract.

  4. When prompted, click Extract And Reload Into A New Database.

    When prompted, click Extract Structure And Data.

  5. Follow the instructions in the wizard and accept the defaults.

Results

The new remote database is created with the appropriate schema, remote users, publications, subscriptions, and triggers. By default, the data from the consolidated database is extracted to the remote database and the subscriptions are started. However, the wizard does not start the SQL Remote Message Agent, so no messages are exchanged.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0