| 摘 要: 随着企业对信息系统的依赖性日益增加，数据库作为信息系统的核心承担着重要作用。为了缓解服务器 访问压力，提升读写效率，很多数据库管理员选择搭建服务器集群。通过数据主从复制技术可以实现集群内部服务器之 间数据的同步，实现负载均衡。本文对SQL Server数据库发布/订阅模式下的三种同步方案进行研究，并通过事务发布 方式实现数据的同步。 |
| 关键词: SQL Server；数据同步；主从复制 |
|
中图分类号: TP392
文献标识码: A
|
|
| Research and Application of Data Synchronization Scheme Based on SQL Server |
|
CHEN Xiao
|
( Xuzhou Finance and Economics Branch, Jiangsu Union Technical Institute, Xuzhou 221008, China)
|
| Abstract: With the increasing reliance on information systems in the enterprises,database,as the core of information systems,is undertaking the extremely vital role.To alleviate the pressure of read and write access and enhance the effect of application responses,many database administrators tend to build server clusters to accomplish data synchronization between the servers and load balancing by using the technology of data master-slave replication.This paper studies three replication schemes of SQL Server database publish/subscribe model,and accomplishes data synchronization through publish/subscribe model. |
| Keywords: SQL Server;data synchronization;master-slave replication |
