Database difference detection method and device

The invention discloses a database difference detection method and device. The method comprises the following steps: reading a table structure file of a to-be-detected production database; establishing a production database and a test database according to the table structure file; analyzing a production script file of the to-be-detected production database into an SQL file, and performing simulation execution on the production database according to the SQL file to generate a first production database; and performing difference comparison on the first production database and the test database to generate a comparison report. According to the database difference detection method and device provided by the technical scheme of the invention, the comparison report can be generated under the condition of non-direct connection with the production database, simulation execution is performed on the production script, and production faults caused by script omission can be avoided. 本发明公开了一种数据库的差异检测方法及装置，所述方法包括：读取待检测生产数