What is Replication in SQL Server

Question

Hi What is Replication in SQL Server. What are the types of Replication ?

Satyapriya Nayak · Answer

Hi Arun Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication you can distribute data to different locations and to remote or mobile users over local and wide area networks dial-up connections wireless connections and the Internet. Please refer the below links http://msdn.microsoft.com/en-us/library/ms151198.aspx http://msdn.microsoft.com/en-us/library/ms152531.aspx Thanks