One configuration publisher
At the publisher, perform the following steps:
(1) The Configure Publishing and Distribution Wizard appears from the Copy submenu of the Tools Drop-down menu (Configure Publishing, Subscribers, and distribution)
(2) [Next] Select the Distributor to select the Publisher itself as a Distributor or other SQL Server
(3) [next] set up the snapshot folder
Generally using the default \\servername\d$\Program Files\Microsoft SQL Server\MSSQL\REPLDATA
* * (4) [Next] Custom configuration
You can choose:
Yes, let me set the distribution database properties enable the Publisher or set publishing settings
No, use the following default settings
We recommend that you use custom settings
(5) [Next] set the distribution database name and location with default values
(6) [Next] enable the Publisher to select the server to publish as
(7) [next] Select the database and publication type you want to publish
(8) [Next] Select Register Subscriber
(9) [Next] Complete the configuration
Two Create a publication
At the publishing server
(1) Choose the Create and manage publications 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) A dialog box pops up when you click Next in the Prompt dialog box in the Create Publication Wizard.
The contents of the dialog box are three types of replication. We now choose the first one is also the default snapshot release (the other two people can go to see Help)
(4) Click Next to specify the type of database server that can subscribe to this publication.
SQL Server allows data replication between different databases, such as Oracle or access.
But here we choose to run the SQL Server 2000 database server
(5) Click on [Next] system to pop up a definition of the article dialog box is to select the table to publish
Note: If you have previously selected a transactional publication, you can only select a table with a primary key in this step
(6) Select the publication name and description
* * (7) Custom publication properties
The selections provided by the wizard:
Yes, I will customize the data filter, enable anonymous subscriptions and or other custom properties
Whether to create a publication according to the specified method
Suggest a custom approach
(8) [Next] Select how you want to filter the publication
(9) [Next] You can choose whether to allow anonymous subscriptions
1 If you select a branding subscription, you need to add a subscriber at the publisher
Methods: [Tools]->[replication]->[Configuration Publications, subscribers, and Distribution properties]->[subscribers]
Otherwise, you will be prompted for a subscription at the Subscriber: change publication does not allow anonymous subscriptions
If you still need anonymous subscriptions, use the following workaround
[Enterprise Manager]->[replication]->[Publishing Content]->[Properties]->[subscription options] Select Allow anonymous pull subscriptions
2 If you select an anonymous subscription, the above prompts will not appear when you configure the Subscriber
(10) [Next] Set up the Snapshot Agent scheduler
(11) [Next] Complete the configuration
When you finish creating your publication, the database that creates the publication becomes a shared database.
The configuration of a three-subscriber server
(i) The configuration of a push subscription
At the publisher
[Enterprise Manager]->[replication]->[Publishing Content]->[Properties]->[subscription]->[Force New]
Then the Push Subscription Wizard appears
Select Subscriber-> Subscription database name-> set Distribution Agent schedule-> Initialize subscription-> start required service
(Agent of Publisher to start)-> complete
(ii) configuration of Pull subscriptions
The following actions are performed at the Subscriber
(1) Select [Pull subscriptions] from the [Tools] Pull-down Menu [Copy] submenu
(2) SELECT [Request New subscription] Open Pull Subscription Wizard
(3) [Next] Select registered Publications
(4) [next] Select the database to create the subscription
(5) [Next] Choose an anonymous subscription or a signed subscription
(6) [Next] Initialize subscription Select initialization schema and data
(7) [next] Select the location where the snapshot files are stored generally using the default snapshot folder of the publisher
* * (8) [next] set up the Distribution Agent schedule to select the interval at which subscriptions update content
(9) [Next] The system prompts you to check the status of the publisher's proxy service
(10) [Next] Complete the configuration
Current 1/2 page
12 Next read the full text
