Design and Implementation of ShenTong Database Comparison Tool based on ODBC under Kylin Platform

Abstract

At present, there is no effective ShenTong database comparison software under the domestic Kylin operating system platform. The database comparison is mainly performed manually, which may cause heavy workload and high error rate. This article mainly studies the ShenTong database content comparison method based on Unix ODBC interface under the Kylin operating system platform, designs a software-based comparison method using ODBC driver, and implements the ShenTong database comparison software by executing SQL scripts or statements, which can compare two database instances, show the difference of tables and records, edit and synchronize the instances. At present, the software has been successfully applied to the maritime tracking and control software system, which greatly improved the work efficiency.