Copying a database

Copying is the process of duplicating a set of databases from the source to a destination by physically copying the underlying devices. In this case, you are copying a set of databases from a source Adaptive Server to a destination Adaptive Server.

The quiesce database for an external dump includes the extension for creating the manifest file, then use a utility or command external to Adaptive Server, (tar, zip or the UNIX dd command) to move or copy the database to the destination Adaptive Server. The datadump and the manifest file are then shipped to the destination Adaptive Server. Data is extracted and placed on devices at the destination Adaptive Server by the tar, unzip or dd command.

If a device is used for more than one database, all of the databases on that device must be moved in one operation.