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

This article shows you mssql data synchronization how to achieve data replication, the content is concise and easy to understand, absolutely can make your eyes bright, through the detailed introduction of this article, I hope you can get something.

1 configure the publisher

Perform the following steps at the publisher:

(1) Select "configure Publishing, subscriber and Distribution" from the "copy" submenu of the [tools] drop-down menu to appear the configure Publishing and Distribution Wizard.

(2) [next] Select the distributor. You can choose the publisher itself as the distributor or other sql server.

(3) [next] set the snapshot folder

Generally, the default\\ servername\ d$\ Program Files\ Microsoft SQL Server\ MSSQL\ ReplData is adopted.

* * (4) [next] Custom configuration

You can choose from:

Yes, let me set the distribution database properties to enable the publisher or set the publishing settings

No, use the following default settings

Custom settings are recommended

(5) [next] set the distribution database name and location to the default value

(6) [next] enable the publisher to select as the publishing server

(7) [next] Select the database and type of publication to be published

(8) [next] Select a registered subscriber

(9) [next] complete the configuration

Second, create a publication

On the publisher

(1) Select the create and manage releases command from the copy submenu of the tools menu.

(2) Select the database where you want to create the publication, and then click "create publication"

(3) Click next in the prompt dialog box of the create release Wizard and a dialog box will pop up.

The contents on the dialog box are three types of replication. We now choose the first, that is, the default snapshot release (the other two can take a look at help)

(4) Click "next". The system requires you to specify the type of database server that can subscribe to the publication.

SQLSERVER allows data replication between different databases such as ORACLE or ACCESS.

But here we choose the database server running "SQL SERVER 2000"

(5) Click "next" and the system will pop up a dialog box to define the article, that is, select the table to be published.

Note: if you selected transaction publication previously, you can only select tables with primary keys in this step.

(6) Select the release name and description

* * (7) Custom publish attributes

Options provided by the wizard:

I will customize data filtering, enable anonymous subscriptions and or other custom properties

Whether to create the publication according to the specified method

It is recommended to adopt a custom way.

(8) [next] choose the way to filter the publication

(9) [next] you can choose whether to allow anonymous subscriptions.

1) if you choose a signed subscription, you need to add a subscriber at the publisher

Method: add from [tools]-> [copy]-> [configure Properties for Publishers, subscribers and Distributors]-> [subscribers]

Otherwise, the prompt that appears when requesting a subscription at the subscriber: changing the publication does not allow anonymous subscription.

If anonymous subscriptions are still required, use the following solutions

[enterprise Manager]-> [copy]-> [publication]-> [Properties]-> [subscription options] Select to allow anonymous request subscriptions

2) if you choose anonymous subscription, the above prompt will not appear when configuring the subscriber

(10) [next] set Snapshot Agent schedule

(11) [next] complete the configuration

When the publication is created, the database that creates the publication becomes a shared database.

3. Configuration of subscribers

(1) configuration of compulsory subscription

On the publisher

[enterprise Manager]-> [copy]-> [publish]-> [Properties]-> [subscription]-> [Force New]

Then the forced subscription wizard appears

Select subscriber-> subscribe database name-> set Distribution Agent schedule-> initialize subscription-> start required services

(the agent of the publisher needs to be started)-> finish.

(2) configuration of pull subscriptions

Do the following at the subscriber

(1) Select "request subscription" in the "copy" submenu from the "tools" drop-down menu.

(2) Select "request New subscription" to open the pull subscription wizard.

(3) [next] Select a registered release

(4) [next] Select the database to create the subscription

(5) [next] Select anonymous subscription or signed subscription

(6) [next] initialize subscription selection initialization schema and data

(7) [next] Select the location of snapshot files. Generally, the default snapshot folder of the publisher is used.

* * (8) [next] set the interval at which the Distribution Agent schedule can choose to subscribe to updates

(9) [next] the system will be prompted to check the running status of the agent service of the publisher.

(10) [next] complete the configuration

The above content is mssql data synchronization how to achieve data replication, have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.