Contents Index The Unload utility and replication Stopping the LTM

ASA Database Administration Guide
  Replicating Data with Replication Server
    Using the LTM

Replicating an entire database


Adaptive Server Anywhere provides a short cut for replicating an entire database, so you don't have to set each table in the database as a replicated table.

You can set a PUBLIC database option called REPLICATE_ALL using the SET OPTION statement. You can designate a whole database for replication using the following command:

SET OPTION PUBLIC.Replicate_all='ON'

You require DBA authority to change this and other PUBLIC option settings. You must restart the database for the new setting to take effect. The REPLICATE_ALL option has no effect on procedures.

For more information, see REPLICATE_ALL option [replication].


Contents Index The Unload utility and replication Stopping the LTM