January 19, 2011 12 Comments
Replication is a very useful method of copying data from production systems to standby servers, reporting servers, and downstream data relay points. Unfortunately, it is an often misunderstood and/or overlooked technology, even among experienced DBAs. In my professional career, I have often seen replication misused in an attempt to achieve a goal for which it was not intended. When it is determined that replication is the correct solution (making that determination will be the subject of a future article), you must install and configure three basic components (these are extremely simplified definitions):
- Publisher: This is the source database or databases containing the information you want to replicate.
- Distributor: This is the database and set of jobs responsible for queuing replicated data from the publisher.
- Subscriber: This is the destination database or databases for data coming from the publisher.
Push and Pull, as named in the title of this article,are the two methods available for Read more of this post