Tuesday, February 21, 2012

replication/database mirroring

After reading about it, i'm still confused. Is replication and database mirroring the same? they seem to accomplish the same thing.No they are not the same. They are different technologies to attain high availability. While in Replication, the subscriber is available for querying and for reporting purposes, the mirrored DB is inaccessible. You can however create a snapshot of the mirror and use the snapshot Db which is in read only mode. Check out BOL for more differences.|||Additionally some flavors of Tran replication and Merge replication allow writes at subscribers and conflict detection/resolution.

No comments:

Post a Comment