SQL Server replication

However, I think this function is also useful for setting backup servers or testing servers,

Publishing Services on one machine can be subscribed to in the SQL statements of other machines. Depending on your publishing conditions, you can publish and subscribe to different services, such as scheduled synchronization, real-time synchronization, and mutual synchronization.

To support the replication function of SQL Server, you must run the SQL Server Agent service. Otherwise, snapshots cannot be generated.

 

Set the publisher and distributor.

 

This is the SQL Server Agent Proxy Server that must be enabled as mentioned above. Otherwise, the subscription fails.

 

 

 

This is the release type, which can be selected based on the actual situation.

 

 

The table to be published must have a primary key. Tables without a primary key cannot be used for publishing.

 

 

You can also set the fields to share.

 

 

Different execution statuses can be selected here.

 

 

Pay attention to setting security settings here. Many new users do not set security settings here, so they cannot subscribe to the products after they put the changes in order.

 

 

To set it to the SQL Server login name

 

 

Set successfully.

 

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

You are welcome to join us.