Objective: To realize the synchronization of the basic data from the main server database in the hospital outpatient emergency system. Methods:the data of the trigger, stored procedure, and merge statement are used to synchronize the data, and the performance of these methods are analyzed. Results:several methods are able to achieve the synchronization of data from master and slave. Conclusion:According to the actual situation of the hospital, we should choose the suitable method to synchronize data.%目的:实现医院门诊应急系统中基础数据从主服务器数据库中同步。方法:利用触发器、存储过程、merge语句分别进行数据同步,并对这几种方法进行性能分析。结果:几种方法都能高效实现主从数据库数据的同步。结论:根据医院实际情况,选择适合的方法同步数据。
展开▼