Extract a consolidated database and reload the schema and data into a new database. No interim copy of the data is created on disk.
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.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the consolidated database.
Click Tools >> SQL Anywhere 16 » Extract Database.
Choose the consolidated database to connect to and extract.
When prompted, click Extract And Reload Into A New Database.
When prompted, click Extract Structure And Data.
Follow the instructions in the wizard and accept the defaults.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|