Methods for detecting compatibility of application program and relevant database script and performing upgrading maintenance on application program and relevant database script

Abstract

The invention discloses methods for detecting the compatibility of an application program and a relevant database script and performing upgrading maintenance on the application program and the relevant database script and relates to the field of detection and maintenance of application programs and databases. A version number maintenance mechanism which is the same as that of the application program is adopted for updating the database script, the upgrading process of the application program and the database script is managed by using a version number, the database script or the application program which is required to be upgraded is determined by comparing the version number of the required database script of the application program with the version number of the current database script of the application program, and a universal method for upgrading the application program and the database script is provided. By adoption of the methods, the compatibility of the application program and the database script can be conveniently determined, the version number of the application program or the database script which is required to be upgraded is definitely provided if the application program and the database script are incompatible, the upgrading maintenance cost of the application program and the database script is reduced, and the efficiency is improved.

Description

technical field [0001] The invention relates to the field of detection and maintenance of application programs and databases, in particular to a method for automatically detecting compatibility and upgrade maintenance of application programs and related database scripts. Background technique [0002] In the "client-server" architecture, when the application is deployed on multiple client machines, and the application needs regular maintenance and upgrades, one of the difficulties usually faced is how to maintain and ensure that each client The application program on the machine is consistent with the database version on the server side. Specifically, the following questions are included: [0003] 1) After the database script on the server side is upgraded, how does each client application detect and obtain this information, so as to avoid incompatibility, abnormal function, or even crash of the client application. [0004] 2) When a client installs an application of a diff...

AI Technical Summary

Problems solved by technology

Using flags to judge can partially solve this problem, but the choice of flags is not clear, and it is impossible to judge the required version of the corresponding application program according to the server-side database script, so as to give the user a clear enough prompt message (this is in a widely deployed, continuous very important in an upgraded application environment)

In addition, this method does not give a clear and feasible solution to the upgrade and maintenance of database scripts

Images