Data replication: Which Type and When to Use

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.