Transactional Replication

Sometimes called synchronous replication, this type of data replication assumes and uses a constant live connection between databases to replicate content (data) or to pass application calls (RPCs) on a near real-time basis.

When this type of replication is used, the system replicates each transaction to the remote site as soon as the user saves the changes. It assumes that both the target and source sites are always connected through the SQL sever and that they have the same schema.