CN113515306B - System transplanting method and device - Google Patents
System transplanting method and device Download PDFInfo
- Publication number
- CN113515306B CN113515306B CN202110454524.8A CN202110454524A CN113515306B CN 113515306 B CN113515306 B CN 113515306B CN 202110454524 A CN202110454524 A CN 202110454524A CN 113515306 B CN113515306 B CN 113515306B
- Authority
- CN
- China
- Prior art keywords
- database
- data
- determining
- source database
- transplanted
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000006243 chemical reaction Methods 0.000 claims abstract description 62
- 238000002054 transplantation Methods 0.000 claims abstract description 5
- 238000013508 migration Methods 0.000 claims description 33
- 230000005012 migration Effects 0.000 claims description 33
- 230000006870 function Effects 0.000 claims description 24
- 238000013509 system migration Methods 0.000 claims description 23
- 238000004590 computer program Methods 0.000 claims description 10
- 238000005192 partition Methods 0.000 claims description 10
- 239000000758 substrate Substances 0.000 claims 8
- 238000010586 diagram Methods 0.000 description 11
- 238000004891 communication Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 7
- 230000006978 adaptation Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 239000000835 fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000013515 script Methods 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/76—Adapting program code to run in a different environment; Porting
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a system transplanting method and device, and relates to the technical field of big data. One embodiment of the method comprises the following steps: acquiring operation data of a source database in a first system; determining the difference between the source database and a target database in a second system according to the operation data; determining conversion relations corresponding to the source database and the target database according to the differences; and according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted into the second system. The embodiment can ensure that the data and the application before and after the transplantation are matched with the second system, thereby improving the efficiency of the system transplantation and being convenient for the normal operation of the system after the transplantation.
Description
Technical Field
The present invention relates to the field of big data technologies, and in particular, to a method and an apparatus for system migration.
Background
In financial or other business systems, system migration may be involved in a facility upgrade or retrofit process. The software and hardware before and after the system migration may be different, and the stock data and applications involved in these systems are also more, so how to ensure the adaptation of the data format and applications before and after the data migration is a problem to be solved.
Disclosure of Invention
In view of this, the embodiments of the present invention provide a method and an apparatus for system migration, which can determine a difference between a source database in a first system before migration and a target database in a second system after migration according to operation data of the source database in the first system before migration, and determine a conversion relationship between the source database and the target database according to the difference, so as to migrate an application and data in the first system to the second system according to the determined conversion relationship, thereby ensuring adaptation between data before and after migration and the application and the second system, so as to improve efficiency of system migration, and facilitate normal operation of the system after migration.
To achieve the above object, according to one aspect of the embodiments of the present invention, there is provided a system migration method, including:
acquiring operation data of a source database in a first system; the first system includes: the system comprises an X86 server, a Redhat Linux operating system, a Weblogic middleware and an Oracle database;
determining the difference between the source database and a target database in a second system according to the operation data; the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a dream database;
determining conversion relations corresponding to the source database and the target database according to the differences;
and according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted into the second system.
Optionally, the method comprises:
converting the data to be transplanted and the application to be transplanted in the source database according to the conversion relation;
and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
Optionally, the method further comprises:
the operational data includes any one or more of the following: the configuration information of the source database, table data of the source database, sql statements corresponding to the source database, functions corresponding to the source database, triggers, space usage data of the source database and server pressure data.
Optionally, when the running data includes the sql statement, the method includes:
determining a database schema definition language according to the sql statement;
analyzing the database schema definition language and determining grammar differences of the source database and the target database;
and determining the conversion relation according to the grammar difference.
Optionally, the method further comprises:
determining a data manipulation language according to the sql statement;
and analyzing the difference of the source database and the target database about data manipulation languages, and determining the conversion relation according to the difference.
Optionally, the method further comprises:
determining a data type corresponding to the source database according to the table data of the source database;
and determining the difference between the data type corresponding to the source data and the data type of the target database, and determining the database field type conversion relation according to the difference.
Optionally, the method further comprises:
and determining the difference of the functions included in the source database and the target database, and determining the conversion relation corresponding to the functions according to the difference.
Optionally, the method further comprises:
and acquiring an automatic load information report of the source database, and determining the space use data and the server pressure data according to the automatic load information report.
Optionally, the method comprises:
unloading the converted data to be transplanted from the source database, and importing the converted data to be transplanted into the target database;
optionally, the method comprises:
and transplanting the converted data to be transplanted to the target database by using a data migration tool of the target database.
Optionally, the method comprises:
and converting codes corresponding to the application to be transplanted according to the conversion relation of the database field types and the calling relation of the application to be transplanted and the data to be transplanted.
Optionally, the method comprises:
and determining a partition strategy of the target database according to the space use data and/or the server pressure data of the source database, and configuring the second system according to the partition strategy.
Optionally, the method comprises:
and modifying the target database according to the service type corresponding to the application to be transplanted, wherein the service type comprises online service and/or batch service.
Optionally, the method comprises:
and modifying the configuration file, the domain configuration and the used code corresponding to the application to be converted according to the difference between the Baoland middleware and the Weblogic middleware, and configuring the second system according to the modified application to be converted.
To achieve the above object, according to still another aspect of the embodiments of the present invention, there is provided an apparatus for system migration.
The device for transplanting the system in the embodiment of the invention comprises: the device comprises an acquisition module, a difference determination module and a transplantation module; wherein,,
the acquisition module is used for acquiring the operation data of the source database in the first system; the first system includes: the system comprises an X86 server, a Redhat Linux operating system, a Weblogic middleware and an Oracle database;
the difference determining module is used for determining the difference between the source database and the target database in the second system according to the operation data; the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a dream database;
the transplanting module is used for determining a conversion relation corresponding to the source database and the target database according to the difference; and according to the conversion relation, the data and the application in the first system are transplanted to the second system.
Optionally, the migration module is configured to convert the data to be migrated and the application to be migrated in the source database according to the conversion relationship;
and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
Optionally, the migration module is configured to determine a database schema definition language according to the sql statement;
analyzing the database schema definition language and determining grammar differences of the source database and the target database;
and determining the conversion relation according to the grammar difference.
Optionally, the migration module is configured to determine a data manipulation language according to the sql statement;
and analyzing the difference of the source database and the target database about data manipulation languages, and determining the conversion relation according to the difference.
Optionally, the migration module is configured to determine a data type corresponding to the source database according to table data of the source database;
and determining the difference between the data type corresponding to the source data and the data type of the target database, and determining the database field type conversion relation according to the difference.
Optionally, the migration module is configured to determine a difference between functions included in the source database and the target database, and determine a conversion relationship corresponding to the functions according to the difference.
To achieve the above object, according to still another aspect of the embodiments of the present invention, there is provided an electronic device for system migration.
The electronic equipment for system migration in the embodiment of the invention comprises: one or more processors; and the storage device is used for storing one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors are enabled to realize the system transplanting method of the embodiment of the invention.
To achieve the above object, according to still another aspect of the embodiments of the present invention, there is provided a computer-readable storage medium.
A computer-readable storage medium of an embodiment of the present invention has stored thereon a computer program which, when executed by a processor, implements a method of system migration of an embodiment of the present invention.
One embodiment of the above invention has the following advantages or benefits: the method can determine the difference between the source database and the target database in the second system after the transplanting according to the operation data of the source database in the first system before the transplanting, and determine the conversion relation between the source database and the target database according to the difference, and further transplant the application and the data in the first system into the second system according to the determined conversion relation, thereby ensuring the adaptation of the data before and after the transplanting and the application and the second system, improving the efficiency of the system transplanting and facilitating the normal operation of the system after the transplanting. When the first system is a foreign system and the second system is a domestic system, the conversion relation from the foreign operating system to the domestic operating system can be obtained by analyzing the difference between the current foreign operating system and the domestic operating system, so that the operation system can be transplanted to home, monopoly of foreign enterprises on the information system architecture is broken, and information security of China is facilitated.
Further effects of the above-described non-conventional alternatives are described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a schematic diagram of the main steps of a method of system migration according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of the main modules of a system migration apparatus according to an embodiment of the present invention;
FIG. 3 is an exemplary system architecture diagram in which embodiments of the present invention may be applied;
fig. 4 is a schematic diagram of a computer system suitable for use in implementing an embodiment of the invention.
Detailed Description
Exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, in which various details of the embodiments of the present invention are included to facilitate understanding, and are to be considered merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
It should be noted that the embodiments of the present invention and the technical features in the embodiments may be combined with each other without collision.
Fig. 1 is a schematic diagram of the main steps of a method of system migration according to an embodiment of the present invention.
As shown in fig. 1, the method for system migration according to the embodiment of the present invention mainly includes the following steps:
step S101: acquiring operation data of a source database in a first system;
in one embodiment of the invention, the operational data includes any one or more of the following: the configuration information of the source database, table data of the source database, sql statements corresponding to the source database, functions corresponding to the source database, triggers, space usage data of the source database and server pressure data. And acquiring an automatic load information report of the source database, and determining the space use data and the server pressure data according to the automatic load information report.
Specifically, the automatic Load information report (Automatic Workload Repository), also called as AWR report, includes database details, host configuration information, start-stop time and duration of the AWR report (snappshot information), system Load condition (Load Profile), top 10Foreground Events by Total Wait Time, database resource proportion occupied by each process (Time Model Statistics), performance index of operating system layer (Operating System Statistics), SQL statement information of occupied resources (SQL Statistics), etc.
Step S102: determining the difference between the source database and a target database in a second system according to the operation data;
in one embodiment of the invention, the first system comprises: the system comprises an X86 server, a Redhat Linux operating system, a Weblogic middleware and an Oracle database; the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a dream database. And modifying the configuration file, the domain configuration and the used code corresponding to the application to be converted according to the difference between the Baoland middleware and the Weblogic middleware, and configuring the second system according to the modified application to be converted.
Specifically, the war file needs to be analyzed and modified, namely, the configuration file related to weblogic in the war package is modified, such as weblogic. To analyze and reform the domain configuration, the application programs in weblogic are all organized in the domain, and the source application server (weblogic) information collected before is configured correspondingly on the target application server; analyzing and modifying the jar package, analyzing the jar package strongly coupled with webogic, and modifying codes used in application.
Step S103: determining conversion relations corresponding to the source database and the target database according to the differences;
in one embodiment of the invention, when the run data includes the sql statement, determining a database schema definition language according to the sql statement; analyzing the database schema definition language and determining grammar differences of the source database and the target database; and determining the conversion relation according to the grammar difference.
Specifically, DDL languages (Data Definition Language, database schema definition languages) involved in the database are combed, whereby a difference analysis is performed on a source database (Oracle) and a target database (dary database). Among them, DDL language is a language for describing real world entities to be stored in a database, which is an integral part of SQL language (Structured Query Language ).
In one embodiment of the invention, a data manipulation language is determined from the sql statement; and analyzing the difference of the source database and the target database about data manipulation languages, and determining the conversion relation according to the difference.
Specifically, the differences between the source database (Oracle) and the target database (dar's dream database) at the DML (Data Manipulation Language ) operation level are summarized, summarizing the database operations that may be used therein. And determining the conversion relation of Oracle to the dream database according to the difference of the source database and the target database at the operation level and the operation of the corresponding database.
In one embodiment of the invention, determining a data type corresponding to the source database according to table data of the source database; and determining the difference between the data type corresponding to the source data and the data type of the target database, and determining the database field type conversion relation according to the difference.
Specifically, the field types contained in the source database (Oracle) and the field types related to the system are statistically analyzed, and the field types of the target database (dar Meng database) are analogized, the difference of the field types in the source database and the target database is found, and the alternative scheme of the field types of the database is defined, namely, the conversion relation of the field types of the database is determined.
In one embodiment of the present invention, the code corresponding to the application to be transplanted is converted according to the conversion relationship of the database field types and the call relationship between the application to be transplanted and the data to be transplanted.
Specifically, when a database is migrated from an Oracle database to a dream database, operations such as replacing JDBC driver packages (Java Database Connectivity, java database connections), configuring data source links, and driver class names need to be acquired. Where JDBC is an application program interface in the Java language that is used to specify how a client program accesses a database. After the system is correctly connected to the dream database, the corresponding codes need to be adjusted according to the data types modified in the database migration process.
In one embodiment of the present invention, a difference between functions included in the source database and the target database is determined, and a conversion relationship corresponding to the functions is determined according to the difference.
Specifically, the function of the source database (Oracle) and the special grammar used in the storage process are analyzed, and the difference of the special grammar in the function use and storage process of the source database (Oracle) and the target database (Dart database) is determined according to the analysis result, so that the conversion relation of the Oracle database to the dream database is determined.
In one embodiment of the invention, a partition policy of a target database is determined according to space usage data and/or server pressure data of the source database, and the second system is configured according to the partition policy.
Specifically, an initialization script of the first system is analyzed, including data types, data lengths of the dream database, and DDL statements of the transformation build table are analyzed. If some applications have special partition requirements, the initialization scripts need to be analyzed one by one, so that a partition strategy of the dream database is formulated to configure the second system.
In one embodiment of the present invention, the target database is modified according to a service type corresponding to the application to be transplanted, where the service type includes an online service and/or a batch service.
In particular, there is a need to retrofit online services of a first system, including real-time transactions and near real-time transactions. In addition, it is necessary to modify the batch traffic of the first system. And deploying the modified first system into an original application server (weblogic) for verification, thereby confirming the correctness and the validity of the database transplanting part and the change part of the system application.
Step S104: and according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted into the second system.
In one embodiment of the invention, the data to be transplanted and the application to be transplanted in the source database are converted according to the conversion relation; and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
In one embodiment of the invention, unloading the converted data to be transplanted from the source database and importing the converted data to be transplanted into the target database; and transplanting the converted data to be transplanted to the target database by using a data migration tool of the target database.
Specifically, the files can be unloaded from the Oracle database and then imported into the dream database, and the DM data migration tool (DTS) provided by the dream database can be used for stock data migration, wherein the tool provides the functions of table, view, index and the like of the mainstream large database (Oracle, mySQL, DB and the like) for migrating the dream database.
According to the embodiment of the invention, the difference between the source database and the target database in the second system after the transplanting can be determined according to the operation data of the source database in the first system before the transplanting, the conversion relation between the source database and the target database is determined according to the difference, and then the application and the data in the first system are transplanted into the second system according to the determined conversion relation, so that the adaptation of the data before and after the transplanting and the application and the second system is ensured, the efficiency of the system transplanting is improved, and the normal operation of the system after the transplanting is facilitated. When the first system is a foreign system and the second system is a domestic system, the conversion relation from the foreign operating system to the domestic operating system can be obtained by analyzing the difference between the current foreign operating system and the domestic operating system, so that the operation system can be transplanted to home, monopoly of foreign enterprises on the information system architecture is broken, and information security of China is facilitated.
Fig. 2 is a schematic diagram of main modules of an apparatus for system migration according to an embodiment of the present invention.
As shown in fig. 1, a system migration apparatus 200 according to an embodiment of the present invention includes: an acquisition module 201, a variance determination module 202, and a migration module 203.
Wherein,,
the acquiring module 201 is configured to acquire operation data of a source database in a first system;
the difference determining module 202 is configured to determine, according to the operation data, a difference between the source database and a target database in a second system;
the migration module 203 is configured to determine a conversion relationship corresponding to the source database and the target database according to the difference; and according to the conversion relation, the data and the application in the first system are transplanted to the second system.
In one embodiment of the present invention, the obtaining module 201 is configured to obtain an automatic load information report of the source database, and determine the space usage data and the server pressure data according to the automatic load information report.
In one embodiment of the present invention, the migration module 203 is configured to convert the data to be migrated and the application to be migrated in the source database according to the conversion relationship; and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
In one embodiment of the present invention, the migration module 203 is configured to determine a database schema definition language according to the sql statement; analyzing the database schema definition language and determining grammar differences of the source database and the target database; and determining the conversion relation according to the grammar difference.
In one embodiment of the invention, the operational data includes any one or more of the following: the configuration information of the source database, table data of the source database, sql statements corresponding to the source database, functions corresponding to the source database, triggers, space usage data of the source database and server pressure data.
In one embodiment of the present invention, the migration module 203 determines a database schema definition language according to the sql statement; analyzing the database schema definition language and determining grammar differences of the source database and the target database; and determining the conversion relation according to the grammar difference.
In one embodiment of the present invention, the migration module 203 determines a data manipulation language according to the sql statement; and analyzing the difference of the source database and the target database about data manipulation languages, and determining the conversion relation according to the difference.
In one embodiment of the present invention, the migration module 203 determines a data type corresponding to the source database according to table data of the source database; and determining the difference between the data type corresponding to the source data and the data type of the target database, and determining the database field type conversion relation according to the difference.
In one embodiment of the present invention, the difference determining module 202 determines a difference between functions included in the source database and the target database, and determines a conversion relationship corresponding to the functions according to the difference.
In one embodiment of the present invention, the migration module 203 uninstalls the converted data to be migrated from the source database and imports the converted data to be migrated into the target database;
in one embodiment of the present invention, the migration module 203 utilizes a data migration tool of the target database to migrate the converted data to be migrated to the target database.
In one embodiment of the present invention, the difference determining module 202 converts the code corresponding to the application to be transplanted according to the database field type conversion relationship and the call relationship between the application to be transplanted and the data to be transplanted.
In one embodiment of the present invention, the migration module 203 determines a partition policy of the target database according to the space usage data and/or the server pressure data of the source database, and configures the second system according to the partition policy.
In one embodiment of the present invention, the migration module 203 reforms the target database according to a service type corresponding to the application to be migrated, where the service type includes an online service and/or a batch service.
In one embodiment of the present invention, the first system includes: the system comprises an X86 server, a Redhat Linux operating system, a Weblogic middleware and an Oracle database;
the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a dream database.
In one embodiment of the present invention, the migration module 203 reforms a configuration file, a domain configuration and a code that are used and correspond to the application to be converted according to the difference between the branded middleware and the Weblogic middleware, and configures the second system according to the reformed application to be converted.
The embodiment of the invention also provides a server, which comprises: one or more processors; and a storage device for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement the identification method as provided in any of the embodiments above.
The embodiment of the present invention also provides a computer readable medium having stored thereon a computer program which, when executed by a processor, implements an identification method as provided in any of the above embodiments.
Fig. 3 illustrates an exemplary system architecture 300 of a system migration method or system migration apparatus to which embodiments of the present invention may be applied.
As shown in fig. 3, the system architecture 300 may include terminal devices 301, 302, 303, a network 304, and a server 305. The network 304 is used as a medium to provide communication links between the terminal devices 301, 302, 303 and the server 305. The network 304 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.
A user may interact with the server 305 via the network 304 using the terminal devices 301, 302, 303 to receive or send messages or the like. Various communication client applications, such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc., may be installed on the terminal devices 301, 302, 303.
The terminal devices 301, 302, 303 may be a variety of electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.
The server 305 may be a server providing various services, such as a background management server providing support for shopping-type websites browsed by the user using the terminal devices 301, 302, 303. The background management server can analyze and other processing on the received data such as the product information inquiry request and the like, and feed back processing results (such as target push information and product information) to the terminal equipment.
It should be noted that, the method for system migration provided in the embodiment of the present invention is generally executed by the server 305, and accordingly, the device for system migration is generally disposed in the server 305.
It should be understood that the number of terminal devices, networks and servers in fig. 3 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Referring now to FIG. 4, there is illustrated a schematic diagram of a computer system 400 suitable for use in implementing an embodiment of the present invention. The terminal device shown in fig. 4 is only an example, and should not impose any limitation on the functions and the scope of use of the embodiment of the present invention.
As shown in fig. 4, the computer system 400 includes a Central Processing Unit (CPU) 401, which can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 402 or a program loaded from a storage section 408 into a Random Access Memory (RAM) 403. In RAM 403, various programs and data required for the operation of system 400 are also stored. The CPU 401, ROM 402, and RAM 403 are connected to each other by a bus 404. An input/output (I/O) interface 405 is also connected to bus 404.
The following components are connected to the I/O interface 405: an input section 406 including a keyboard, a mouse, and the like; an output portion 407 including a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker, and the like; a storage section 408 including a hard disk or the like; and a communication section 409 including a network interface card such as a LAN card, a modem, or the like. The communication section 409 performs communication processing via a network such as the internet. The drive 410 is also connected to the I/O interface 405 as needed. A removable medium 411 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed on the drive 410 as needed, so that a computer program read therefrom is installed into the storage section 408 as needed.
In particular, according to embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network via the communication portion 409 and/or installed from the removable medium 411. The above-described functions defined in the system of the present invention are performed when the computer program is executed by a Central Processing Unit (CPU) 401.
The computer readable medium shown in the present invention may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules involved in the embodiments of the present invention may be implemented in software or in hardware. The described modules may also be provided in a processor, for example, as: a processor includes an acquisition module, a variance determination module, and a migration module. The names of these modules do not in any way limit the module itself, and the acquisition module may also be described as a "module for acquiring the operation data of the source database in the first system", for example.
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be present alone without being fitted into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to include: acquiring operation data of a source database in a first system; determining the difference between the source database and a target database in a second system according to the operation data; determining conversion relations corresponding to the source database and the target database according to the differences; and according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted into the second system.
According to the technical scheme of the embodiment of the invention, the difference between the source database and the target database in the second system after the transplanting can be determined according to the operation data of the source database in the first system before the transplanting, the conversion relation between the source database and the target database is determined according to the difference, and then the application and the data in the first system are transplanted into the second system according to the determined conversion relation, so that the adaptation of the data before and after the transplanting and the application and the second system is ensured, the efficiency of the system transplanting is improved, and the normal operation of the system after the transplanting is facilitated. When the first system is a foreign system and the second system is a domestic system, the conversion relation from the foreign operating system to the domestic operating system can be obtained by analyzing the difference between the current foreign operating system and the domestic operating system, so that the operation system can be transplanted to home, monopoly of foreign enterprises on the information system architecture is broken, and information security of China is facilitated.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives can occur depending upon design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.
Claims (14)
1. A method of system migration, comprising:
acquiring operation data of a source database in a first system; the first system includes: the system comprises an X86 server, a Redhat Linux operating system, a Weblogic middleware and an Oracle database;
determining the difference between the source database and a target database in a second system according to the operation data; the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a dream database; the operation data includes: the configuration information of the source database, table data of the source database, sql statements corresponding to the source database, functions corresponding to the source database, triggers, space usage data of the source database and server pressure data;
according to the difference, determining a conversion relation corresponding to the source database and the target database, including: determining a data type corresponding to the source database according to the table data of the source database; determining a difference between a data type corresponding to the source database and a data type of the target database, and determining a database field type conversion relation according to the difference;
according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted into the second system, and the method comprises the following steps: and converting codes corresponding to the application to be transplanted according to the conversion relation of the database field types and the calling relation of the application to be transplanted and the data to be transplanted.
2. The method of claim 1, wherein the step of determining the position of the substrate comprises,
converting the data to be transplanted and the application to be transplanted in the source database according to the conversion relation;
and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
3. The method of claim 1, wherein when the run data comprises the sql statement,
determining a database schema definition language according to the sql statement;
analyzing the database schema definition language and determining grammar differences of the source database and the target database;
and determining the conversion relation according to the grammar difference.
4. The method of claim 1, wherein the step of determining the position of the substrate comprises,
determining a data manipulation language according to the sql statement;
and analyzing the difference of the source database and the target database about data manipulation languages, and determining the conversion relation according to the difference.
5. The method of claim 1, wherein the step of determining the position of the substrate comprises,
and determining the difference of the functions included in the source database and the target database, and determining the conversion relation corresponding to the functions according to the difference.
6. The method of claim 1, wherein the step of determining the position of the substrate comprises,
and acquiring an automatic load information report of the source database, and determining the space use data and the server pressure data according to the automatic load information report.
7. The method of claim 2, wherein the step of determining the position of the substrate comprises,
unloading the converted data to be transplanted from the source database, and importing the converted data to be transplanted into the target database.
8. The method of claim 2, wherein the step of determining the position of the substrate comprises,
and transplanting the converted data to be transplanted to the target database by using a data migration tool of the target database.
9. The method of claim 1, wherein the step of determining the position of the substrate comprises,
and determining a partition strategy of the target database according to the space use data and/or the server pressure data of the source database, and configuring the second system according to the partition strategy.
10. The method as recited in claim 2, further comprising:
and modifying the target database according to the service type corresponding to the application to be transplanted, wherein the service type comprises online service and/or batch service.
11. The method of claim 1, wherein the step of determining the position of the substrate comprises,
and modifying the configuration file, the domain configuration and the used code corresponding to the application to be transplanted according to the difference between the Baoland middleware and the Weblogic middleware, and configuring the second system according to the modified application to be transplanted.
12. A system migration apparatus, comprising: the device comprises an acquisition module, a difference determination module and a transplantation module; wherein,,
the acquisition module is used for acquiring the operation data of the source database in the first system; the first system includes: the system comprises an X86 server, a Redhat Linux operating system, a Weblogic middleware and an Oracle database;
the difference determining module is used for determining the difference between the source database and the target database in the second system according to the operation data; the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a dream database; the operation data includes: the configuration information of the source database, table data of the source database, sql statements corresponding to the source database, functions corresponding to the source database, triggers, space usage data of the source database and server pressure data;
the migration module is configured to determine, according to the difference, a conversion relationship corresponding to the source database and the target database, and includes: determining a data type corresponding to the source database according to the table data of the source database; determining a difference between a data type corresponding to the source database and a data type of the target database, and determining a database field type conversion relation according to the difference; and according to the conversion relation, migrating the data and the application in the first system to the second system, wherein the migration comprises the following steps: and converting codes corresponding to the application to be transplanted according to the conversion relation of the database field types and the calling relation of the application to be transplanted and the data to be transplanted.
13. An electronic device for system migration, comprising:
one or more processors;
storage means for storing one or more programs,
when executed by the one or more processors, causes the one or more processors to implement the method of any of claims 1-11.
14. A computer readable medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the method according to any of claims 1-11.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110454524.8A CN113515306B (en) | 2021-04-26 | 2021-04-26 | System transplanting method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110454524.8A CN113515306B (en) | 2021-04-26 | 2021-04-26 | System transplanting method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113515306A CN113515306A (en) | 2021-10-19 |
| CN113515306B true CN113515306B (en) | 2023-04-25 |
Family
ID=78063848
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110454524.8A Active CN113515306B (en) | 2021-04-26 | 2021-04-26 | System transplanting method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113515306B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117851434B (en) * | 2024-03-07 | 2024-05-14 | 深圳市雁联计算系统有限公司 | Method, system and storage medium for concurrent migration of database |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2013002937A2 (en) * | 2011-06-29 | 2013-01-03 | Microsoft Corporation | Virtual machine migration tool |
| KR101762283B1 (en) * | 2016-05-19 | 2017-07-31 | 주식회사 티맥스 소프트 | Method and computer program stored in computer-readable medium for converting sort script to reuse jcl in different encoding environment |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050138606A1 (en) * | 2003-12-17 | 2005-06-23 | Sujit Basu | System and method for code migration |
| US10162612B2 (en) * | 2016-01-04 | 2018-12-25 | Syntel, Inc. | Method and apparatus for inventory analysis |
| US10970277B2 (en) * | 2016-01-20 | 2021-04-06 | Oracle International Corporation | System and method for dynamic conversion of database accessing scripts during runtime in a mainframe rehosting platform |
| US10268633B2 (en) * | 2016-03-29 | 2019-04-23 | Wipro Limited | System and method for database migration with target platform scalability |
| US11550785B2 (en) * | 2019-04-19 | 2023-01-10 | Oracle International Corporation | Bidirectional mapping of hierarchical data to database object types |
| CN110968566A (en) * | 2019-11-01 | 2020-04-07 | 广东省信息工程有限公司 | Migration tool-based domestic application system migration method |
| CN112685081A (en) * | 2020-12-15 | 2021-04-20 | 建信金融科技有限责任公司 | System migration method and device, electronic equipment and storage medium |
-
2021
- 2021-04-26 CN CN202110454524.8A patent/CN113515306B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2013002937A2 (en) * | 2011-06-29 | 2013-01-03 | Microsoft Corporation | Virtual machine migration tool |
| KR101762283B1 (en) * | 2016-05-19 | 2017-07-31 | 주식회사 티맥스 소프트 | Method and computer program stored in computer-readable medium for converting sort script to reuse jcl in different encoding environment |
Non-Patent Citations (1)
| Title |
|---|
| 段永见 ; .ORACLE到DB2应用移植方法探讨.科技资讯.2007,(11),全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113515306A (en) | 2021-10-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110019350B (en) | Data query method and device based on configuration information | |
| CN111786939B (en) | Method, device and system for testing management platform of Internet of things | |
| CN110795147A (en) | Interface protocol file management method and device | |
| CN111125064B (en) | Method and device for generating database schema definition statement | |
| US11934287B2 (en) | Method, electronic device and computer program product for processing data | |
| CN113515306B (en) | System transplanting method and device | |
| CN110764769B (en) | Method and device for processing user request | |
| CN113326305A (en) | Method and device for processing data | |
| CN111752916B (en) | Data acquisition method and device, computer readable storage medium and electronic equipment | |
| CN112988583A (en) | Method and device for testing syntax compatibility of database | |
| CN113672671A (en) | Method and device for realizing data processing | |
| CN111414154A (en) | Method and device for front-end development, electronic equipment and storage medium | |
| CN116204428A (en) | Test case generation method and device | |
| CN113779122B (en) | Method and device for exporting data | |
| CN110806967A (en) | Unit testing method and device | |
| CN113779018A (en) | Data processing method and device | |
| CN112925772A (en) | Data dynamic splitting method and device | |
| CN112214500A (en) | Data comparison method and device, electronic equipment and storage medium | |
| CN113268417B (en) | Task execution method and device | |
| CN117235052B (en) | Database statement processing method and device | |
| CN115563183B (en) | Query method, query device and program product | |
| US11799982B2 (en) | Message push method, apparatus, device and medium | |
| US20230289354A1 (en) | Endpoint scan and profile generation | |
| CN109388536B (en) | Data collection method and device | |
| CN116775446A (en) | Interface testing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |