Synchronizing with the SQL Remote Message Agent (dbremote)

Replace the current contents of subscribed tables with a new copy.

Prérequis

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Contexte et remarques

Use the Extraction utility (dbxtract) or the Extract Database Wizard to synchronize subscriptions. See Synchronizing subscriptions.

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.

Task

Connect to the consolidated database.
Execute a SYNCHRONIZE SUBSCRIPTION statement.

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.

Résultat

The current contents of the subscribed tables are replaced with the new copy.

Cautions

Do not execute a SYNCHRONIZE SUBSCRIPTION statement on a remote database Execute SYNCHRONIZE SUBSCRIPTION statements at the consolidated database.
Large volume of messages may result Synchronizing databases over a message system can require large volumes of messages. Also, the size of the message can exceed the size of the remote database. Synchronizing many subscriptions over a message link can increase the amount of message traffic.
Often, it is recommended that you extract the remote databases and then manually load the data.