Data replication: Which Type and When to Use

Friday Apr 2nd 2010 by DatabaseJournal.com Staff

Data replication types are each unique and have both good and bad aspects.

There are several different types of data replication, each unique and having things it’s both good and bad for. There is SAN replication which is mostly used for high availability purposes, but depending on configuration may also be used for disaster recovery. Then there are three kinds of SQL replication: transactional, merge, and snapshot. Choosing which type and when to deploy depends solely on the environment and individual requirement of your company.
Mobile Site | Full Site