.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Post New Resource Bookmark and Share   

Replication in sql server

Posted By:Ramesh P       Posted Date: October 30, 2010    Points: 50    Category:    URL: http://www.dotnetspark.com  

It helps to learn about replication in sql server.

Replication : It helps to copy and move the data between one database to another database (or) one server to another server. It uses publisher and subscriber. First data is copied into publisher and then it is moved to subscriber.
There are three types of replication. They are,

1. Snapshot replication
2. Transaction replication
3. Merge Replication

Snapshot Replication : It helps to copy and move the entire database every time replicates.

Transaction Replication : Once changes are made in the publisher it automatically move from publisher to subscriber every times it replicates

Merge Replication : It allows the changes are made in both publisher and subscriber.


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend