Select all the roles that you would like to apply. The New User dialog box disappears and the newly created database user ID appears in the Details pane. Data replication in its simplest form is copying data from its source to a destination or multiple destinations. Data replication is different from data distribution since data distribution is manual, while replications are autonomous. After data replication is configured, no intervention is required by the Database Administrator.
Data replication allows data to be replicated across the room or across the world automatically.
Without data replication, multiple sites would have slow access to their data. Having multiple sites around the world with the same data, load balancing becomes a reality, and the data is always reachable. In brief, if you are a Publisher, you are a server that makes its data available for replication to other servers. The Publisher specifies which data is to be replicated and flags changes made to the data since the last synchronisation process occurred. To make sure this data integrity is maintained, any data element that is replicated has one and only one Publisher.