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].
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|