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].