Database Replication

Database replication is the process of copying a database in a special way so that two or more database copies can exchange updates of data. This exchange between databases is called synchronization. This operation is called an exchange because synchronization normally occurs in both directions, though you can choose to synchronize in one direction if you so desire. Each duplicate of the database is called a replica, which contains a common set of database objects.

The database with which you start is converted to a Design Master. Each replica is part of a replica set, which contains the Design Master and the other replicas. The Design Master is the only replica that enables you to make changes to the structure of the database. ...

Get Access 2002 Programming by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.