# emprepsync

    EMPREPSYNC(1)                                       EMPREPSYNC(1)

    NAME
           emprepsync - performs replication synchronization

    SYNOPSIS
           emprepsync  [-fv] replicate_database replicate_table [
           replicate_table]...

    DESCRIPTION
           emprepsync  is  the  Replication  Synchronization  Utility
           which  synchronizes  the  data  of  one  or more replicate
           tables indicated by replicate_table in replicate_database,
           with  the  data  of their corresponding Replication Master
           Tables. More than one  replicate_table  belonging  to  the
           same replicate_database can be synchronized using one call
           of emprepsync Replication Synchronization Utility.

           For each replicate table replicate_table, there is defined
           an  ordered Replication Master List of one or more associ-
           ated Replication Master Tables. emprepsync  "chooses"  a
           Replication  Master  Table  that  is "enabled" and has the
           smallest Replication Master Order in a Replication  Master
           List  and  attempts  to  connect to the Replication Master
           Server assigned to the "chosen" Replication Master  Table.
           If a connection with the Replication Master Server serving
           a "chosen" Replication Master  Table  can  not  be  estab-
           lished,  emprepsync will try to choose another Replication
           Master Table which has a larger Replication  Master  Order
           until either a successful connection is established, or no
           other Replication Master Table is remained in the list  to
           be  tried.  If  no  connection with any of the Replication
           Master  Tables  in  Replication  Master  List  of   repli-
           cate_table  can  be  established, emprepsync exits with an
           error message.

           After the first successful  connection  to  a  Replication
           Master  Server,  emprepsync will try to synchronize repli-
           cate_table with the chosen Replication  Master  Table.  If
           this  synchronization  fails,  the  partial effects of the
           synchronization will be rolled back, and the other  Repli-
           cation Master Tables will not be tried.

           If  used  without -f (force) option, emprepsync refuses to
           synchronize a replicate_table more  recent  data,  with  a
           Replication Master Table having less recent data.

           -v    This option causes emprepsync to show verbose on
                 synchronization progress  status,  so that the user  would
                 know whether the synchronization is in progress or not.

           -f    This option forces emprepsync to synchronize repli-
                  cate_table   with   the  Replication  Master  Table
                  accessed by the successfully connected  Replication
                  Master Server assigned by chosen Replication Master
                  Entry, even if the contents of replicate_table  are
                  more  recent  than  that  of its Replication Master
                  Table.  Note  that  [-f]  option  works  only  when
                  Current  Master  Table  Start  Timestamp  (CMTS) of
                  replicate_table is equal to CMTS of its Replication
                  Master  Table participating in the Replication Syn-
                  chronization.

    FILES
           EMPRESS database files.

    SEE ALSO
           empsvadm(1)

           Empress: Replication Server

    HISTORY
           Written by Empress Software Inc.  All  material  is  copy-
           righted and licensed.  Use on non-licensed CPUs is prohib-
           ited.