摘要
针对控制河段船舶通行指挥系统中多信号台数据与服务器需要实时同步的问题,提出利用SQL Server事务复制技术实现多信号台的数据库与服务器数据库上数据的实时同步,并基于SQL Server数据库提供的Sql Dependecy类通过C#编程对整个同步过程进行监视,实现主控端服务器能够知道何时接收到新的船舶AIS信息。
In view of the problem of data synch between signal stations and server on intelligent command system of controlled waterway, this paper proposes using the transactional replication technology of SQL Server to realize data synch. Furthermore, the process of synchronous monitoring program based on SqlDependecy class is created for the server knowing when ships＇ AIS messages were synchronized.
出处
《水运工程》
北大核心
2014年第11期24-27,共4页
Port & Waterway Engineering
关键词
控制河段
SQL数据同步
事务复制
同步监视
controlled waterway
data synchronization on SQL
transactional replication
synchronous monitor
