About Replicating a Database
This Help book describes the actions required to enable replication of databases under SQL Server Express:
- To configure SQL Server and Windows Firewall.
- To configure the replication process so that it can be run and repeated.
- To run a replication process on the command line and check its log file.
The replication process does not use the Microsoft SQL Server's Replication process, which has a different configuration process.
What is replication?
Replication consists in copying data from one database table to another. After a bidirectional (two-way) replication process between two tables, they will contain exactly the same data as each other. The process synchronizes the states of the databases at the level of rows (records, values).
This is accomplished by copying all data that is present
in table A (but not in table B) to table B, and copying all data that
is present in table B (but not in table A) to table A. 
Show
diagram
For instance if records have been deleted from database A but not from database B, replication will restore them to database A.
The process of replication
Replication follows a uniform process: select and connect
each database, then link the tables and filter the data if required. These
steps are explained in the rest of this book. Show flowchart
