Step 1/2 of MSSQL Data Synchronization for Data Replication

Source: Internet
Author: User

1. Configure the Publishing Server
On the Publishing Server, perform the following steps:
(1) select [configuration Publishing, subscription server and Distribution] from the [copy] sub-menu in the [tools] drop-down menu to see the configuration publishing and distribution wizard
(2) [next] You can select the distributor as the distributor or another SQL Server.
(3) [next] set the snapshot folder
The Default \ servername \ D $ \ Program Files \ Microsoft SQL Server \ MSSQL \ repldata
** (4) [next] custom configuration
You can select:
Yes. Let me set the attributes of the distribution database to enable the Publishing Server or set the publishing settings.
No, use the following default settings
Custom settings are recommended.
(5) [next] use the default value to set the name and location of the Distribution Database
(6) [next] enable the Publishing Server and select as the Publishing Server
(7) [next] select the database and release type to be released
(8) [next] Select register subscription Server
(9) [next] complete configuration
Ii. Create a publication
On the Publishing Server
(1) Select the [create and manage release] command from the [copy] sub-menu in the [tools] menu.
(2) Select the database for which you want to create the publication, and click [Create release]
(3) In the prompt dialog box of the [Create release wizard], click [next]. A dialog box is displayed.
The dialog box contains three types of copies. Now we select the first one, that is, the default snapshot release (the other two can be checked for help)
(4) Click [next] system requirements to specify the database server type that can subscribe to the release,
Sqlserver allows data replication between different databases, such as oracle or access.
But here we choose to run the database server "SQL Server 2000"
(5) Click [next] And a definition will pop up. Article Dialog box is used to select the table to be published.
NOTE: If transaction publishing is selected, only tables with primary keys can be selected in this step.
(6) Select the release Name and description.
** (7) custom publishing attributes
Selection provided by the Wizard:
Yes. I will filter custom data, enable Anonymous subscription, and other custom attributes.
No create a release according to the specified Method
We recommend that you use a custom method.
(8) [next] Select a method for filtering and Publishing
(9) [next] You can select whether anonymous subscription is allowed
1) if you select "signed Subscription", you need to add a subscription server to the Publishing Server.
Method: [tools]-> [copy]-> [configure attributes of publishing, subscription server, and Distribution]-> Add in [subscription server]
Otherwise, a prompt will be displayed when you request subscription on the subscription server: you cannot subscribe anonymously if you change the subscription to publish.
If anonymous subscription is still required, use the following solution:
[Enterprise Manager]-> [copy]-> [publish content]-> [properties]-> [subscription options] Select allow anonymous request subscription
2) if you select Anonymous subscription, the above prompt will not appear When configuring the subscription server.
(10) [next] setting snapshot proxy Program Scheduling
(11) [next] complete configuration
After the publication is created, the database for creating the publication becomes a shared database.
Configuration of three subscription servers
(1) configuration of forced subscription
On the Publishing Server
[Enterprise Manager]-> [copy]-> [publish content]-> [properties]-> [subscription]-> [force create]
Then the force subscription wizard appears.
Choose subscription Server> subscription database name> set distribution Agent Scheduling> initialize subscription> Start required services
(The agent of the Publishing Server must be started.)-> complete.
(2) configuration of request subscription
On the subscription server, perform the following operations:
(1) select [request subscription] from the [tools] drop-down menu in the [copy] submenu
(2) select [request a new subscription] to open the request 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] Select initialization Architecture and Data for initialization subscription
(7) [next] select the storage location of the snapshot file. Generally, the default snapshot folder of the release server is used.
** (8) [next] You can set the interval between subscription and update content for the distribution agent scheduling.
(9) [next] The system will prompt you to check the running status of the proxy service of the Publishing Server
(10) [next] complete configuration

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.