SQL Server replication Features _mssql

But I think this feature is also useful for setting up a backup server or a test server.

On a single machine to publish services, you can subscribe to other machines in the SQL, according to your release of different conditions, you can make a timed synchronization, real-time synchronization, synchronization and other different publications and subscriptions.

To enable 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 figure above.

Here's what's mentioned above. The SQL Server Agent proxy Server that must be turned on will not be subscribed to.

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 the shared fields here.

Here you can choose a different execution state.

Note here to set the security settings, many novice is not set up here, the inverted release after the subscription is not.

To be set as a SQL Server logon name

Setup succeeded.

In fact, the published table will have a system automatically added key, full interface of the operation is quite simple.

While learning, we welcome you to exchange.