Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to achieve the replication function in SQL Server. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

But I think it's also useful to set up a backup server or a test server.

Publishing services on one machine can be subscribed in the SQL of other machines. According to your publishing conditions, you can make different publications and subscriptions, such as timing synchronization, real-time synchronization, mutual synchronization, and so on.

For SQL Server to support replication, you must run the SQL Server Agent service, or you will not be able to generate snapshots.

Set up the publisher and distributor in the image above.

Here is the SQL Server Agent proxy server mentioned above, otherwise you will not be able to subscribe to it.

This is the choice of release type, there are four types, you can choose according to the actual situation.

The table to be published must have a primary key, and a table without a primary key cannot be used as a publication.

You can also set up sharing those fields here.

Different execution states can be selected here.

Here, we should pay attention to setting the security settings. Many novices have not set them here and cannot subscribe to them after the inverted release.

To set to the SQL Server login name

The setting was successful.

In fact, all published tables will have a Key automatically added by the system, and the full interface operation is quite simple.

After reading the above, do you have any further understanding of how to achieve replication in SQL Server? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.