Method of relation data base applications automatic upgrade

Abstract

The invention discloses a method for automatically upgrading a relational database application, comprising the following steps: creating a target version database structure; a database automatic upgrading system scanning and analyzing the source version database structure to obtain the source version database structure information; and automatically upgrading the database The system scans and analyzes the target version database structure to obtain the target version database structure information; compares and analyzes the source and target version database structure information to generate an upgrade strategy; executes the upgrade according to the upgrade strategy. The present invention automatically generates an upgrade strategy by automatically analyzing and upgrading the database structure of the source version and the target version, which truly and completely reflects the database information of the source version and the target version, and avoids the possibility of the upgrade tool and The information of the on-site version is disconnected, and the database upgrade and rollback between any versions can be completed conveniently and flexibly.

Description

technical field [0001] The invention relates to an upgrading method, in particular to an automatic upgrading method for a relational database application. Background technique [0002] In order to meet the current needs of various business development and operation management, equipment or software product suppliers have developed various business software based on commercial database software such as MS SQL, Oracle, and Sybase. The main form is to use commercial database software to create database entities occupying a certain storage space, a series of relational data tables, and possibly database elements such as stored procedures and triggers. However, due to the continuous emergence of new business and new requirements, the growth of business volume, the fault repair and function enhancement of software versions, frequent upgrades to the business database system will occur. The upgrade of the database mainly includes the addition and deletion of tables, the change of t...

AI Technical Summary

Problems solved by technology

[0003] 1. It is not possible to judge from the user database system itself whether the database structure has been modified between the two versions. It can only be judged according to the version number of the version which database structure has been modified in the version. This judgment will inevitably lead to errors

For example, some modifications to the database fail to reflect the changes in the version number, resulting in different database structures (possibly very small) corresponding to the same version number. At this time, the database upgrade tool customized according to the version number cannot be completely updated. upgrade correctly

It is possible that at the product operation site, the user has made some modifications, or the technical support personnel have made some changes on site. At this time, the customized database upgrade tool cannot perceive these on-site changes;

[0004] 2. In theory, there will be more than one version conversions during the version upgrade. In this way, relying on different version numbers to customize the version upgrade tool will make the maintenance workload of the data upgrade tool increase with the version number increased sharply

Since the upgrade tool itself cannot recognize the internal database structure of different versions, the reverse rollback also needs to be customized for different versions, which is time-consuming and laborious

Images