Add a New Source Table to an Existing Replication Process
This section provides instructions on how to add a new table from the source database to an existing replication process.
The procedure ensures that the table is incorporated without interrupting any ongoing replication activities or associated services. The serverconfig utility will be used to facilitate the addition of the new table to the replication configuration.
Below process user required to be follow to add a new table at source :
Then run serverconfig with below command :
<path_to_serverconfig> -addtabletopub -s <path_to_publication.config> -sub <path_to_subscription.config> -tables <comma_separated_table_list>That’s all. The table will be auto-created and added to the replication process.
To create ad hoc snapshot for a table already in replication
An ad hoc snapshot may be required to synchronize historical data for specific tables within the replication environment. This process is particularly useful when discrepancies are identified in the historical data between the source and target tables.
The ad hoc snapshot operation does not interfere with the ongoing replication activities, nor does it introduce any risk of data inconsistency. This functionality is designed to provide users with an efficient method for correcting historical data mismatches without impacting the performance or integrity of the replication system.
To create an ad hoc snapshot run the following command :
<path_to_serverconfig> -adhocsnapshot -s <path_to_publication.config> -tables <comma_separated_table_list>