What is replication and why should one use it?
Replication is the process of creating and maintaining replica versions of database objects (e.g. tables) in a distributed database system. Replication can improve performance and increase availability of applications because alternate data access options becomes available. For example, users can access a local database rather than a remote server to minimize network traffic. Furthermore, the application can continue to function if parts of the distributed database are down as replicas of the data might still accessible.
Related Questions
- I have caches configured with asynchronous replication or distribution, but these caches appear to be behaving synchronously (waiting for responses), what is going on?
- I want to use Merge Replication to synchronise data to my SQL Server CE database. Are there any how-to whitepapers available?
- How do enable compression when using SQL Server Merge Replication?
