Database upgrading method and device, equipment and storage medium

Abstract

The invention discloses a database upgrading method and device, equipment and a storage medium, and the method comprises the steps: reading table information in a test library, and generating a corresponding target test record table according to the read table information; querying a production record table in a production library according to the target test record table, determining whether a target production record table corresponding to the target test record table exists in the production library, and obtaining a corresponding target record table existence condition; and generating a corresponding upgrading statement to upgrade table information in the production library based on the existence condition of the target record table and the table structure difference condition of the target test record table and the target production record table. The corresponding upgrading statement is generated based on the difference between the target test record table and the target production record table, major production accidents caused by wrong scripts submitted by developers are avoided, the version upgrading time is saved, the table structure difference between the test environment and the production environment is solved, and the version upgrading accuracy is effectively improved.

Description

technical field [0001] The invention relates to the field of computers, in particular to a database upgrading method, device, equipment and storage medium. Background technique [0002] In the development of the system website or APP (Application, application program), the version is often updated and iterated, and the code needs to be updated frequently, and the structure of the corresponding database also needs to be updated and maintained frequently. In the traditional system upgrade work, the database upgrade work requires operation and maintenance personnel to extract DDL (data definition language, data definition language), DML (data manipulation language, data manipulation language), view and other scripts provided in the upgrade version package for execution, so that Maintain the production environment database to keep the production environment consistent with the test environment. There may be some problems in this way, for example, the scripts provided by the dev...

AI Technical Summary

Problems solved by technology

There may be some problems in this way, for example, the script provided by the developer may be inaccurate, the operation and maintenance personnel may have a script execution error when executing the script, or there are too many scripts, which are easy to miss

Moreover, in the long-term update iteration, maintaining the database according to the script provided in the version package will cause the database in the test environment to be inconsistent with the database in the production environment, causing a great risk in the version upgrade work

Images