SQL Server 2000 replication synchronization configuration and frequently asked questions (below)

SQL Server 2000 replication synchronization configuration and frequently asked questions (below)

(ii) Distribution, release of server-side configuration and issues

1. Start the configuration publication, subscribe to the service area, and the Distribution Wizard

2. Specify the snapshot shared folder on the network location







3. Complete configuration

4. Start the New Publication Wizard



5. Select the database to publish

6, select Merge publication, so that no matter which end of the data changes will be full range synchronization

7, here can choose to compatible with the old version of SQL Server, the default is only 2000

8. Select the objects in the database you want to publish

9.

11. Set New Publication properties

12. Tick "Allow anonymous subscription"

Question five: If "Allow anonymous subscription" is not checked here, there will be an error in the subscription configuration:

The publisher configuration is complete, of course, some of them do not go absolutely, according to the actual situation, such as the way to publish.

13. Create a new pull subscription

14, add the Publisher, the Publisher is best to define here, or there may be publishing items can not display problems



15. Using SQL Server for authentication

16. Select the database to publish



17, generally if you back up the restored database, rather than import the exported Data migration mode, select No

18, according to the requirements of the selection of synchronization task scheduling







19, the configuration is complete, at this time can verify the two libraries are synchronized, new data to query.

SQL Server 2000 replication synchronization configuration and frequently asked questions (below)