Shulou(Shulou.com)06/01 Report--

There are two steps to publish and subscribe: 1. Publish. 2. Subscription. First publish the data that needs to be synchronized on the data source database server, and then subscribe to the above publication on the target database server. Publish can publish part of the data of a table or the entire table. The following describes the process of publishing and subscribing respectively.

First, release. Publishing needs to be done with the actual server name, not the server's IP address. The information that can be published includes * * Table * *, * * stored procedure * *, and * * user function * *. There will be errors if you use IP, as shown below:

The specific release process is as follows:

1. Locate * * replication * *-* * Local publish * * under the database server, and select * * New publish * *. As shown below:

2. Select the database to be published. As shown below:

3. Select the publishing type. The default type selected here is Snapshot publication. SQL SERVER explains the differences between several release types below. As shown below:

4. Select the class content to be released. As shown below:

On the right side of the figure above is the filtered SQL statement.

5. Set up a snapshot agent. As shown below:

Change the synchronization frequency as shown below:

6. Set up agent security. As shown below:

7. Fill in the release name

8. Complete the release. As shown below:

Second, subscribe. A subscription synchronizes a snapshot of a database publication and synchronizes the data source data of the publication to the target database. The specific subscription process is as follows

1. Find * * replication * *-> * * Local subscription * * under the database server, and select * * New subscription * *. As shown below:

2. Select a subscribed publication. As shown below:

3. Select the location of the distribution agent, as shown below:

4. Select one or more target databases at the subscriber that store the synchronized data. As shown below:

To add multiple subscription databases, click add subscriber. As shown below:

5. Set the security of the distribution agent. As shown below:

6. Set up synchronization schedule. As shown below:

7. Complete the subscription. As shown below:

This completes the whole process of publishing and subscribing.

Here, together with the previous section, we have introduced two ways of SQL Server database synchronization, which I hope will be useful to you.

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.