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].
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|