Data | database
1. Introduction
In the development of the trans-regional invoicing management system, how to achieve data synchronization in different regions, how to maintain the consistency of data, timeliness has become the key to success or failure of the system. We have successfully solved the problem, which is described below.
System environment
Database system: SQL Server 2000
Operating system: WINDOWS Advance Server, IIS 4.0
Network: The sales center is connected to the Internet through a dedicated line, and regional distribution points are connected to the Internet via modem dial-up.
2. Replication strategy
Considering all kinds of factors, such as the close degree of data connection, the reliability of the network and the cost, we choose the way to disperse the data and synchronize the data regularly. To do this, we divide the data into two categories: data that is replicated only in one way (such as the system's underlying data, a portion of the data being processed on a daily basis), data that needs to be replicated both ways (some of the data that is routinely processed) Only one-way copy of the data can be divided into: maintained by the sales center, distributed to the distribution points of data, maintained by the distribution points, summarized to the sales center data. Different types of data require a different replication strategy.
Maintained by the sales center, distributed to the distribution points of the data
Set itself up as a publishing server and distributor on the sales center's SQL Server, define your publication, use things to copy models, and anonymously subscribe. Set up a pull subscription on the SQL Server of the distribution point.
Maintained by each distribution point, aggregated to the sales center database.
In the distribution point of the SQL Server set itself as a Publisher and distributor, the Sales center of SQL Server as a Subscriber. Define your publication and use things to copy the model. and set up push subscriptions to copy the data to the sales center.
Data that needs to be replicated in both directions
Set itself up as a publishing server and distributor on the sales center's SQL Server, define the publication, adopt the merge replication model and the anonymous subscription method. Set up a pull subscription on the SQL Server of the distribution point.
Why do you use the above replication strategy? This is because the sales center has a fixed IP on the computer, and the distribution point of the computer only dynamic IP and data has a different classification.
The above is only a brief introduction to the solution, I hope you will be more valuable advice.
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.