SQL Server Publishing and subscription

I. Configuring distribution

1. Configure the Distributor, note: To configure the publication and subscription, connect to SQL Server must be logged in with the name

2. Configure distribution

3. Select the distribution server

4. Select the snapshot folder

5. Set the Read and write permissions for this folder to everyone

6. Select the distribution database path

7. Configure distribution

8. Configure distribution

9. Configure Distribution Completion

Two. New publication

1. New Publication

2. Select Publish Database

3. Choose a Publication type

4. Select Publish Object

5. Specify when to run the Snapshot Agent

6. Agent Security

7. Create a publication

8. Fill in the publication name

9. New Publication Complete

Three. Create a new subscription

1. Create a new subscription

2. Find the SQL Server Publisher

3. Enter the server name, user name, password

4. Select the publication database

5. Select Distribution Agent Location

6. Select a subscription database

7. Agent Security

8. Select a synchronization schedule

9. Initializing a subscription

10. Subscription Wizard

11. Subscription Wizard

12. New subscription successful, view synchronization status

At this point, the SQL Server publish and subscribe configuration is complete, and the database specified at the Publisher and Subscriber can be synchronized in real time ~ ~

Reproduced in: http://www.cnblogs.com/suixinpeng/p/sqlserver_replication.html

SQL Server Publishing and subscription