Method for zero-modification migration of application program under heterogeneous database platforms

Abstract

The invention discloses a method for the zero-modification migration of an application program under heterogeneous database platforms. An architecture of the method comprises a server side and a client side; the server side consists of two compatible heterogeneous database platforms which are respectively called an original database platform and a new database platform, and the compatibility of the database platforms comprises data types and SQL (Structured Query Language) sentences; the client side consists of the application program and an application program loader, and the application program accesses the database platforms by using an ADO (ActiveX Data Objects) and OLE DB (Object Linking and Embedding Database) mode and is connected with the database platforms by using an ADO and OLEDB connection character string; and the application program loader starts the application program, searches from a memory, replaces a database connection character string of the application program, and closes the running of the application program. According to the method for the zero-modification migration of the application program under the heterogeneous database platforms, the seamless migration and switchover between the two database platforms can be achieved, the workload for application program migration is greatly reduced, and the human, material and financial resources are saved.

Description

technical field [0001] The invention belongs to the heterogeneous database platform migration technology, in particular to a zero-modification migration method for application programs under the heterogeneous database platform. Background technique [0002] With the gradual improvement of people's information awareness, more and more enterprises, organizations and individuals use information systems to manage and control their business, data and processes. In the construction process of the information system, the model of "application + database platform" has been used all the time, in which the database platform plays an extremely critical and core role, and almost all applications rely on the database platform for data acquisition, transmission, organization, Store, query and display to build. The successful application of the database platform is related to the success or failure of the entire information system. [0003] The wide application of information systems, wh...

AI Technical Summary

Problems solved by technology

Changes in the database platform lead to corresponding changes in the application program, otherwise the application program cannot work normally, and the cost of this part is very high. In some cases, it even reaches an intolerable level, which is reflected in: (1) It takes a lot of manpower, Material and financial resources modify the source code of the application. As the scale of the application business system increases, this part of the cost will even increase exponentially, especially when the source code is unmaintained or the developer is replaced; (2) A large number of applications do not even have access to the source code, making modification of the application impossible

Images