Contents Index The Message Agent Extracting a remote database in Sybase Central

SQL Remote User's Guide
  Utilities and Options Reference

The Database Extraction utility


You can access the remote database extraction utility in the following ways:

By default, the extraction utility runs at isolation level zero. If you are extracting a database from an active server, you should run it at isolation level 3 (see Extraction utility options) to ensure that data in the extracted database is consistent with data on the server. Running at isolation level 3 may hamper others' turnaround time on the server because of the large number of locks required. It is recommended that you run the extraction utility when the server is not busy, or run it against a copy of the database (see Designing an efficient extraction procedure).

Objects owned by dbo 

The dbo user ID owns a set of Adaptive Server Enterprise-compatible system objects in an Adaptive Server Anywhere database.

For Adaptive Server Anywhere, the extraction utility does not unload the objects created for the dbo user ID during database creation. Changes made to these objects, such as redefining a system procedure, are lost when the data is unloaded. Any objects created by the dbo user ID since the initialization of the database are unloaded by the Extraction utility, and so these objects are preserved.


Extracting a remote database in Sybase Central
The extraction utility
Extraction utility options

Contents Index The Message Agent Extracting a remote database in Sybase Central