February 21, 2013 at 3:37 am
differences b/w transactionall vs peer to peer ?
February 21, 2013 at 6:24 am
They are very similar as Peer to Peer replication (only available in Enterprise Edition) is based on transactional replication and is both a scale-out and a high availability solution.
Essentially, with P2P you can provide multiple copies of databases across multiple instances that clients can connect to and modify in near real time (even from geographically distinct locations, i.e. subscribers located at different ends of the country).
Transactional replication is best used in an environment where the data changes frequently at the publisher and then replicated to the subscribers, it also has better latency then P2P.
You've also got merge replication which is a whole other kettle of fish 🙂 and includes a more sophisticated data conflict resolution function.
More on P2P replication: http://technet.microsoft.com/en-us/library/ms151196(v=sql.105).aspx
More on tranasactional replication: http://technet.microsoft.com/en-us/library/ms151176(v=sql.105).aspx
More on merge replication: http://technet.microsoft.com/en-us/library/ms152746.aspx
Hope that helps a bit.
M
email: info@weekendwebdesign.co.uk
Personal Website: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply