Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Replicating Data with Replication Server » Using the LTM

The Unload utility and replication Next Page

Replicating an entire database

SQL Anywhere provides a shortcut 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. See replicate_all option [Replication Agent].