Synchronize using the SQL Remote Message Agent (dbremote)

It is recommended that you use the Extraction utility (dbxtract) or the Extract Database Wizard to synchronize subscriptions. See Synchronize.

Extracting a large number of subscriptions, or synchronizing subscriptions to large, frequently-used tables, can slow database access. You can use the SEND AT clause to specify a time to synchronize when the consolidated database is not in heavy use. See Setting the send frequency.

 To synchronize a subscription with the message system (Interactive SQL)
  1. Connect to the consolidated database as a user with DBA authority.

  2. Execute a SYNCHRONIZE SUBSCRIPTION statement. See SYNCHRONIZE SUBSCRIPTION statement [SQL Remote].

    The SQL Remote Message Agent (dbremote) on the consolidated database sends a copy of all rows in the subscription to the subscriber. The SQL Remote Message Agent (dbremote) assumes that an appropriate database schema is in place at the remote databases.

    The SQL Remote Message Agent (dbremote) on the subscriber database receives the synchronization message and it replaces the current contents of the subscribed tables with the new copy.

 Cautions