MSSQL Instance Tutorial: MSSQL Database Synchronization

Source: Internet
Author: User
Tags mssql mssqlserver sql version client

1: the Environment
Server environment:
Machine Name: ZEHUADB (MSSQL)
Operating system: Windows Server
Database version: SQL Server SP4 Personal Edition

Client
Machine Name: ZLP (DANDAN)
Operating system: Windows XP
Database version: SQL Server SP4 Personal Edition

2: Build user account
Create a user account on the server side
My Computer Management-> Local Users and Groups-> user-> Build
Username:zlp
Userpwd:zlp

3: Reboot the server MSSQLServer
My Computer-> control face version-> management tools-> Service->mssqlserver Service
(Change to: User account, our new ZLP user. \ZLP, password: ZLP)

4: Installing the Distributor

A: Configuring the Distributor
Tools-> Replication-> Configure Publishing, subscribers, and distribution-> next-> next (all with default configuration)

B: Configuring the Publisher
Tools-> Replication-> Create and manage Publications-> Select the database to publish (SZ)-> next-> Snapshot publishing-> next->
Select what to publish-> next-> next-> next-> finish

C: Force configuration Subscriber (push mode, pull mode is similar to this)
Tools-> Replication-> Configure Publishing, subscribers, and distribution-> subscribers-> Create a new->sql server database-> Enter a client server name (ZLP)-> Use SQL Server Authentication (SA, blank password)- > Determine-> application->

D: Initializing Subscriptions
Replication Monitor-> Publisher (ZEHUADB)-> Double-click Subscription-> Force new-> next-> Select Enabled Subscribers->zlp->
Next-> next-> next-> next-> complete

5: Test configuration is successful
Replication Monitor-> Publisher (ZEHUADB)-> double-click sz:sz-> Point State-> point to run Agent now
View:
Replication Monitor-> Publisher (ZEHUADB)->sz:sz-> Select Zlp:sz (type coercion)-> right mouse button-> start synchronous processing
If there is no error sign (Red Fork), congratulations on your configuration success

6: Test Data
Execute on server:
Select a table to execute the following SQL
INSERT INTO wq_newsgroup_s Select "Test Succeeded", 5

Replication Monitor-> Publisher (zehuadb)->sz:sz-> snapshot-> boot Agent
->zlp:sz (forced)-> start synchronous processing

To see if the sync wq_newsgroup_s inserted a new record



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.