CN110659255A - Data migration method, device and system and storage medium - Google Patents
Data migration method, device and system and storage medium Download PDFInfo
- Publication number
- CN110659255A CN110659255A CN201810683214.1A CN201810683214A CN110659255A CN 110659255 A CN110659255 A CN 110659255A CN 201810683214 A CN201810683214 A CN 201810683214A CN 110659255 A CN110659255 A CN 110659255A
- Authority
- CN
- China
- Prior art keywords
- database
- migration
- migrated
- log
- target
- 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.)
- Pending
Links
- 230000005012 migration Effects 0.000 title claims abstract description 211
- 238000013508 migration Methods 0.000 title claims abstract description 211
- 238000000034 method Methods 0.000 title claims abstract description 84
- 230000008569 process Effects 0.000 claims abstract description 47
- 238000004590 computer program Methods 0.000 claims description 17
- 230000002159 abnormal effect Effects 0.000 claims description 12
- 230000008676 import Effects 0.000 claims description 12
- 230000010354 integration Effects 0.000 claims description 6
- 230000006870 function Effects 0.000 description 13
- 238000010586 diagram Methods 0.000 description 10
- 230000005856 abnormality Effects 0.000 description 5
- 238000012986 modification Methods 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 230000000694 effects Effects 0.000 description 4
- 230000000007 visual effect Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 238000012550 audit Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Abstract
The invention discloses a data migration method, a device, a system and a storage medium, which relate to the field of computer information, and the method comprises the following steps: acquiring migration parameters, wherein the migration parameters comprise source end information and target end information; migrating the database from the source end device to the target end device according to the migration parameters; acquiring a migration log in the migration process and archiving the migration log; checking the line number of the database before and after the migration to judge whether the data of the database after the migration is matched; and integrating the archived migration log into the migrated database. The remote database can be migrated to the target device only by the user automatically operating after inputting the corresponding source information and target information according to the prompt, for the user, complex database management commands do not need to be input at all, the migration operation of the database can be completed in a one-click manner only by inputting the source information and the target information on the page, and the method is simple and convenient.
Description
Technical Field
The present invention relates to migration of databases, and in particular, to a data migration apparatus, system, method, and storage medium.
Background
The database migration, that is, the database is migrated from one server to another server, is equivalent to a general pasting operation of a file from a directory location of the same device or another device. For the copy-paste operation of the file, only a few mouse clicks are needed to complete, but for the database, it is more complicated to migrate and copy a certain database from the source device to the target device.
The existing mature database migration schemes are all that data export is performed by a professional dba (data base administrator), and then data import is performed in the two basic steps. Obviously, for some non-professional database managers, the migration means needs to know a lot of database knowledge in time and then to be familiar with a lot of database operation commands to complete the migration of the database.
Disclosure of Invention
The invention is made to solve the problem that the database migration process is complex and needs to be operated by specially mastering a learning command line, and aims to provide visual data migration equipment, a system, a method and a storage medium.
The invention provides a database migration method, which is used for migrating a database from a source end device to a target end device and comprises the following steps:
acquiring migration parameters, wherein the migration parameters comprise source end information and target end information;
migrating the database from the source end device to the target end device according to the migration parameters;
acquiring a migration log in the migration process and archiving the migration log;
checking the line number of the migrated database to judge whether the data of the migrated database are matched; and
and integrating the archived migration log into a migrated database.
The database migration method provided by the present invention may further have the following characteristics, and further includes: and displaying the migration log and the migration progress in real time.
The database migration method provided by the invention can also have the following characteristics that:
and an error prompting step, namely displaying error categories according to preset error categories if errors occur during data migration.
The database migration method provided by the present invention may further have a feature that: wherein the error prompting step comprises the following substeps:
checking the data size of a table of a database to be migrated and the data size of an index, judging whether the storage space of the target end equipment is enough relative to the sum of the data size of the table and the data size of the index, if so, carrying out the next step, and if not, stopping migration and exiting;
checking whether the export process is abnormal, if so, carrying out the next step, and if not, stopping migration and exiting;
checking whether a database to be imported exists, if not, directly establishing a database by taking the database to be imported as a name and entering the next step, if so, renaming the database to be different new names, establishing a database by taking the database to be imported as a name and entering the next step;
and importing the database to be imported into the target end database, checking whether an import process is abnormal, checking the line number of the database before and after migration if the import process is normal, judging whether the data of the database after migration is matched, and stopping migration and exiting if the data of the database after migration is abnormal.
The database migration method provided by the present invention may further have the following characteristics, wherein the specific process of checking whether the data of the migrated database are matched is as follows:
acquiring the number of rows of the table of the target end database after migration, judging whether the number of rows of the table of the source end database is consistent with the number of rows of the table of the target end database, if so, judging that the migration is successful, and if not, exiting;
and repeating the previous step for traversing and judging the tables in the target end database after migration according to the table names.
The database migration method provided by the present invention may further have the characteristic that the process of the migration log integration is to store the log information, the database information of the source end, and the database information of the target end in the migration process in the database of the target end after the migration.
The database migration method provided by the present invention may further have a feature that the source end information includes a device identification code and a port of the source end device, and a database name, a database user name, and a database access password to be migrated,
the target end information comprises an equipment identification code and a port of the target end equipment, a database name to be migrated, a database user name and a database access password.
The invention also provides a database migration device, which comprises a memory and a processor, wherein the memory is stored with a computer program running on the processor, and the processor executes the computer program to realize the method.
The present invention also provides a database migration system for migrating a database from a source device to a target device, comprising:
the migration parameter acquisition module is used for acquiring migration parameters, and the migration parameters comprise source end information and target end information;
the migration module is used for migrating the database from the source end equipment to the target end equipment according to the migration parameters;
the log archiving module is used for acquiring and archiving the migration log in the migration process;
the matching judgment module is used for checking the line number of the databases before and after the migration to judge whether the data of the databases after the migration are matched; and
and the log integration module is used for integrating the archived migration log into the migrated database.
The invention also provides a storage medium having stored thereon a computer program which, when executed by a processor, implements the method described above.
The invention has the following functions and effects: the data migration method provided by the invention comprises the following steps: acquiring migration parameters, wherein the migration parameters comprise source end information and target end information; migrating the database from the source end device to the target end device according to the migration parameters; acquiring a migration log in the migration process and archiving the migration log; checking the line number of the database before and after the migration and judging whether the data of the database after the migration is matched; and integrating the filed migration log into the migrated database, wherein the remote database can be migrated into the target device only by inputting corresponding source end information and target end information according to prompts by a user and automatically operating subsequent operations by the system, so that for the user, complicated database management commands do not need to be input at all, the migration operation of the database can be completed in a one-click manner only by inputting the source end information and the target end information on a page, and the problem of complicated operation process in the prior art is solved.
Drawings
FIG. 1 is a flow chart of a database migration method according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating the detailed steps of error prompt; and
fig. 3 is a schematic structural diagram of a database migration system according to an embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples.
As shown in fig. 1, the database migration method for migrating a database from a source device to a target device includes the following steps S1 to S6.
And S1, displaying an input interface for the user to input the migration parameters in the migration process. The migration parameters comprise source end information and target end information, the source end information comprises an equipment identification code and a port of the source end equipment, a name of a database to be migrated, a user name of the database and an access password of the database, and the target end information comprises an equipment identification code and a port of the target end equipment, a name of the database to be migrated, a user name of the database and an access password of the database.
Therefore, a front-end HTML page to be displayed to the user needs to be constructed, and the page is mainly used for selecting or filling in database information of the source end and the target end, including an IP address, a port, a database name, a table name, a database user and a database password. Where the database name and table name may replace all databases or tables with a number. In addition, the page needs to define a display module DIV for displaying the migration log and the migration progress in real time.
S2, obtaining migration parameters, wherein the migration parameters comprise source end information and target end information.
And S3, migrating the database from the source device to the target device according to the migration parameters.
Taking a relatively common MySQL as an example for specific description, the method comprises the following processes:
a) and connecting the target end database with the source end database by using a pymysql module according to the information filled in the front end HTML page.
b) And connecting a target end machine by using SSH, exporting the database data to be migrated, which is specified in HTML by a user, by using a mysqldump command, and storing the database data as a text type file.
c) The method is mainly used for backing up data, preventing the possibility of data loss caused by the mistaken input of a user and facilitating the timely rollback of the mistaken input of the user.
d) And importing the text file exported in the last step into a target end database specified in an HTML page by the user by using a source command.
And S4, acquiring and archiving the migration log in the migration process.
Taking a relatively common MySQL as an example to concretely explain how the operation is implemented:
a) writing ajax function for acquiring log output in real time
The function is mainly used for acquiring log information in the migration process in real time, and continuously loading the latest log information in a display module DIV defined in the first-step front-end HTML.
b) Archiving of functions using Python log output function at backend
For the whole migration process, the log is set in a modularized mode by using the logging module of python, so that the log can be displayed on a page in real time, the filing of the migration log can be guaranteed, and the detailed process of the migration record can be conveniently inquired at any time later.
S5, checking the row number of the database before and after the migration to judge whether the data of the database after the migration is matched.
And checking the number of rows of the migrated database, and judging whether the migrated data is matched with the data before migration, wherein the specific step is that pymyql is used for connecting the source end database and the target end database, and the migrated data is circularly compared according to the table name in the table name and the table name in the target end database. The comparison steps are as follows:
a) and collecting the tables by using the analyze statement, and acquiring the statistical information of the latest table row number.
b) Acquiring the line number of the table from an information _ schema table, judging whether the line number of the table of the source end database is consistent with the line number of the table of the target end database, if so, judging that the migration is successful, and if not, prompting an exception four after exiting: the data consistency check fails;
and repeating the previous step for traversing and judging the tables in the target end database after migration according to the table names.
S6, integrating the archived migration log into the migrated database.
The process is realized by a self-defined audit information function.
At this moment, an audit function needs to be defined for integrating and recording the information of the migration, and the integration process is to store log information, database information of a source end and database information of a target end in the migration process in a database of the target end after the migration. By the operation, the specific log information of the migration is stored in the database, so that the record can be conveniently checked in the future.
As an optional optimized implementation manner, while the step S3 is performed, the following error prompt step S7 is provided.
And S7, an error prompting step, wherein if errors occur during data migration, the error category is displayed according to the preset error classification.
As shown in FIG. 2, the specific steps of error prompt are S7-1 to S7-4:
s7-1, checking the data size of the table and the data size of the index of the database to be migrated, and judging whether the storage space of the target end equipment is larger than or equal to the sum of the data size of the table and the data size of the index, if so, proceeding the next step, if not, stopping migration and prompting an exception after quitting: the target server has insufficient space and cannot be migrated. In this embodiment, the storage space is preferably greater than or equal to twice the sum of the data size of the table and the data size of the index, so that the migration effect is good, and the storage space can be reserved for subsequent log files.
S7-2, checking whether the export process is abnormal, if so, proceeding to the next step, if not, stopping migration, exiting and prompting an abnormality II: the source database derives errors.
S7-3, checking whether the database to be imported exists, if not, directly building a new database by taking the database to be imported as the name and entering the next step, if so, renaming the database to be different new names, building a new database by taking the database to be imported as the name and entering the next step;
s7-4, checking whether an exception exists in the import process, if so, checking the line number of the database before and after migration and judging whether the data of the database after migration are matched, if so, stopping migration and prompting an exception III after exiting: and the target-side database imports errors.
The database migration apparatus provided by the embodiment of the present invention will be described in detail below.
A database migration apparatus comprising a memory and a processor, the memory having stored thereon a computer program that runs on the processor, characterized in that: a method of implementing database migration when a computer program is executed by a processor, the method comprising the steps of:
s1, displaying an input interface for the user to input the migration parameters in the migration process
S2, obtaining migration parameters, wherein the migration parameters comprise source end information and target end information.
And S3, migrating the database from the source device to the target device according to the migration parameters.
And S4, acquiring and archiving the migration log in the migration process.
S5, checking the row number of the database before and after the migration to judge whether the data of the database after the migration is matched.
S6, integrating the archived migration log into the migrated database.
Preferably, the method for implementing database migration when the processor of the database migration apparatus executes the computer program further includes the following steps:
and S7, an error prompting step, wherein if errors occur during data migration, the error category is displayed according to the preset error classification.
As shown in FIG. 2, the specific steps of error prompt are S7-1 to S7-4:
s7-1, checking the data size of the table and the data size of the index of the database to be migrated, and judging whether the storage space of the target end equipment is larger than or equal to the sum of the data size of the table and the data size of the index, if so, proceeding the next step, if not, stopping migration and prompting an exception after quitting: the target server has insufficient space and cannot be migrated. In this embodiment, the storage space is preferably greater than or equal to twice the sum of the data size of the table and the data size of the index, so that the migration effect is good, and the storage space can be reserved for subsequent log files.
S7-2, checking whether the export process is abnormal, if so, proceeding to the next step, if not, stopping migration, exiting and prompting an abnormality II: the source database derives errors.
S7-3, checking whether the database to be imported exists, if not, directly building a new database by taking the database to be imported as the name and entering the next step, if so, renaming the database to be different new names, building a new database by taking the database to be imported as the name and entering the next step;
s7-4, checking whether an exception exists in the import process, if so, checking the line number of the database before and after migration and judging whether the data of the database after migration are matched, if so, stopping migration and prompting an exception III after exiting: and the target-side database imports errors.
The database migration system provided by the embodiment of the invention is described in detail below with reference to the accompanying drawings.
As shown in fig. 3, a database migration system 100 for migrating a database from a source device to a target device includes:
a migration parameter obtaining module 101, configured to obtain a migration parameter, where the migration parameter includes source end information and target end information;
the migration module 102 is configured to migrate the database from the source device to the target device according to the migration parameter;
the log archiving module 103 is configured to obtain a migration log in a migration process and archive the migration log;
a matching judgment module 104, configured to check the number of rows of the database before and after the migration to judge whether the data of the database after the migration is matched; and
a log integration module 105, configured to integrate the archived migration log into the migrated database.
Further, the database migration system 100 may further have an error prompt module 106, which displays error categories according to preset error classifications if an error occurs during data migration:
checking the data size of the table of the database to be migrated and the data size of the index, judging whether the storage space of the target end equipment is enough relative to the sum of the data size of the table and the data size of the index, if so, carrying out the next step, if not, stopping migration and prompting an exception after quitting: the residual space of the target end server is not enough, and the target end server cannot be migrated;
checking whether the export process is abnormal, if so, carrying out the next step, if so, stopping migration, exiting and prompting an abnormality II: a source database exports an error;
checking whether an import process is abnormal or not, if so, checking the line number of the databases before and after the migration and judging whether the data of the databases after the migration are matched or not, if so, stopping the migration and prompting an abnormality after exiting: and the target-side database imports errors.
In this embodiment, the database migration system 100 has a plurality of source end devices () and a plurality of target end devices, and the database migration system 100 may be a certain source end device or a target end device (in this case, the target end device becomes a source end device).
The source end device, the target end device are in communication connection through a communication network, the communication network is a local area network, a wide area network or the internet, the source end device, the target end device and the visual database migration device are all computer systems, the computer systems are generalized computer systems (hardware and software), namely machine systems which can perform storage and operation functions, can receive and store information according to requirements of people, automatically perform data processing and calculation and output result information, and available software operation subsystems of the machine systems comprise MS Windows, Linux, unix, Mac and the like.
In this embodiment, the source device and the target device are microcomputers PCs or servers and workstations, and may be a set of hardware shared by the visual database migration apparatus, the source device and the target device, or may be a single device serving as the database migration apparatus, and the software subsystem uses Linux.
The MySQL database example used in the above embodiments may be other types of databases, such as oracle, MySQL, SQL Server.
The embodiment has the following functions and effects: according to the data migration method provided by the embodiment, the method comprises the following steps: acquiring migration parameters, wherein the migration parameters comprise source end information and target end information; migrating the database from the source end device to the target end device according to the migration parameters; acquiring a migration log in the migration process and archiving the migration log; checking the line number of the database before and after the migration and judging whether the data of the database after the migration is matched; and integrating the filed migration log into the migrated database, wherein the remote database can be migrated into the target device only by inputting corresponding source end information and target end information according to prompts by a user and automatically operating subsequent operations by the system, so that for the user, complicated database management commands do not need to be input at all, the migration operation of the database can be completed in a one-click manner only by inputting the source end information and the target end information on a page, and the problem of complicated operation process in the prior art is solved.
Furthermore, due to the error prompt step, the process in the background running process is monitored in real time, and once a problem occurs, the process can be monitored and prompted.
Because the migration log and the migration progress are displayed in real time, the migration process is visual by displaying the input interface comprising the migration parameter input box and the progress real-time display box, so that the user can input parameters according to the prompt of the input box to perform the migration work of the database, and the migration progress can be known through the progress real-time display box.
Furthermore, because the error prompting step can judge whether the storage space is enough, whether the export process is abnormal and whether the import process is abnormal or not while the migration is performed, namely each key step of the migration can be monitored, even if the abnormality occurs, the problem of which step occurs can be specifically positioned, and thus the targeted investigation and solution can be performed.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.
The present invention is not limited to the above-described embodiments, and it will be apparent to those skilled in the art that various modifications and improvements can be made without departing from the principle of the present invention, and such modifications and improvements are also considered to be within the scope of the present invention. Those not described in detail in this specification are within the skill of the art.
Claims (10)
1. A database migration method for migrating a database from a source device to a target device, comprising the steps of:
acquiring migration parameters, wherein the migration parameters comprise source end information and target end information;
migrating the database from the source end device to the target end device according to the migration parameters;
acquiring a migration log in the migration process and archiving the migration log;
checking the line number of the migrated database to judge whether the data of the migrated database are matched; and
and integrating the archived migration log into a migrated database.
2. The database migration method according to claim 1, further comprising:
and displaying the migration log and the migration progress in real time.
3. The database migration method according to claim 1, further comprising:
and an error prompting step, namely displaying error categories according to preset error categories if errors occur during data migration.
4. The database migration method according to claim 3, wherein said error prompting step comprises the sub-steps of:
checking the data size of the table and the data size of the index of the database to be migrated, judging whether the storage space of the target end equipment is larger than or equal to the sum of the data size of the table and the data size of the index, if so, carrying out the next step, and if not, stopping migration and exiting;
checking whether the export process is abnormal, if so, carrying out the next step, and if not, stopping migration and exiting;
checking whether a database to be imported exists, if not, directly establishing a database by taking the database to be imported as a name and entering the next step, if so, renaming the database to be different new names, establishing a database by taking the database to be imported as a name and entering the next step;
and importing the database to be imported into the target end database, checking whether an import process is abnormal or not, checking the line number of the migrated database and judging whether the data of the migrated database are matched or not if the import process is normal, and stopping migration and exiting if the data of the migrated database is abnormal.
5. The database migration method according to claim 1, wherein the specific process of checking whether the data of the migrated database match is as follows:
acquiring the number of rows of the table of the target end database after migration, judging whether the number of rows of the table of the source end database is consistent with the number of rows of the table of the target end database, if so, judging that the migration is successful, and if not, exiting;
and repeating the previous step for traversing and judging the tables in the target end database after migration according to the table names.
6. The database migration method according to claim 1, wherein:
the process of migration log integration is to store log information, database information of a source end and database information of a target end in the migration process in the database of the target end after migration.
7. The database migration method according to claim 1, wherein:
the source end information comprises a device identification code, a port, a database name to be migrated, a database user name and a database access password of the source end device,
the target end information comprises an equipment identification code and a port of the target end equipment, a database name to be migrated, a database user name and a database access password.
8. A database migration apparatus comprising a memory and a processor, the memory having stored thereon a computer program that runs on the processor, the apparatus comprising: the processor, when executing the computer program, implements the method of any of claims 1 to 7.
9. A database migration system for migrating a database from a source device to a target device, comprising:
the migration parameter acquisition module is used for acquiring migration parameters, and the migration parameters comprise source end information and target end information;
the migration module is used for migrating the database from the source end equipment to the target end equipment according to the migration parameters;
the log archiving module is used for acquiring and archiving the migration log in the migration process;
the matching judgment module is used for checking the line number of the database before and after the migration and judging whether the data of the database after the migration is matched or not; and
and the log integration module is used for integrating the archived migration log into the migrated database.
10. A storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the method of any of claims 1 to 7.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810683214.1A CN110659255A (en) | 2018-06-28 | 2018-06-28 | Data migration method, device and system and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810683214.1A CN110659255A (en) | 2018-06-28 | 2018-06-28 | Data migration method, device and system and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110659255A true CN110659255A (en) | 2020-01-07 |
Family
ID=69026231
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810683214.1A Pending CN110659255A (en) | 2018-06-28 | 2018-06-28 | Data migration method, device and system and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110659255A (en) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111400245A (en) * | 2020-03-25 | 2020-07-10 | 网易(杭州)网络有限公司 | Art resource migration method and device |
CN111462826A (en) * | 2020-04-09 | 2020-07-28 | 合肥本源量子计算科技有限责任公司 | Method for prompting quantum chemical simulation calculation progress, electronic equipment and storage medium |
CN111680023A (en) * | 2020-06-08 | 2020-09-18 | 中国银行股份有限公司 | Migration data checking method and device |
CN112000641A (en) * | 2020-07-31 | 2020-11-27 | 新华三大数据技术有限公司 | Data storage method, device and system |
CN113297182A (en) * | 2021-06-16 | 2021-08-24 | 中国农业银行股份有限公司 | Data migration method, device, storage medium and program product |
TWI782487B (en) * | 2020-04-29 | 2022-11-01 | 香港商希瑞科技股份有限公司 | Method for performing simple storage service seamless migration using index objects, host device, and storage server |
US11516287B2 (en) | 2020-04-29 | 2022-11-29 | Silicon Motion Technology (Hong Kong) Limited | Method and apparatus for performing simple storage service seamless migration using index objects |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070214104A1 (en) * | 2006-03-07 | 2007-09-13 | Bingjie Miao | Method and system for locking execution plan during database migration |
CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
CN105760517A (en) * | 2016-02-25 | 2016-07-13 | 浪潮(北京)电子信息产业有限公司 | Method and device for transferring data from Oracle database to DB2 database |
CN106446166A (en) * | 2016-09-23 | 2017-02-22 | 郑州云海信息技术有限公司 | Method and device for migrating data from DB2 database to K-DB database |
CN106874389A (en) * | 2017-01-11 | 2017-06-20 | 腾讯科技(深圳)有限公司 | The moving method and device of data |
CN107315814A (en) * | 2017-06-29 | 2017-11-03 | 郑州云海信息技术有限公司 | Data consistency checking method and system after a kind of KDB database data migrations |
CN107943889A (en) * | 2017-11-16 | 2018-04-20 | 郑州云海信息技术有限公司 | A kind of migration scheme of MySQL to KDB databases |
-
2018
- 2018-06-28 CN CN201810683214.1A patent/CN110659255A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070214104A1 (en) * | 2006-03-07 | 2007-09-13 | Bingjie Miao | Method and system for locking execution plan during database migration |
CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
CN105760517A (en) * | 2016-02-25 | 2016-07-13 | 浪潮(北京)电子信息产业有限公司 | Method and device for transferring data from Oracle database to DB2 database |
CN106446166A (en) * | 2016-09-23 | 2017-02-22 | 郑州云海信息技术有限公司 | Method and device for migrating data from DB2 database to K-DB database |
CN106874389A (en) * | 2017-01-11 | 2017-06-20 | 腾讯科技(深圳)有限公司 | The moving method and device of data |
CN107315814A (en) * | 2017-06-29 | 2017-11-03 | 郑州云海信息技术有限公司 | Data consistency checking method and system after a kind of KDB database data migrations |
CN107943889A (en) * | 2017-11-16 | 2018-04-20 | 郑州云海信息技术有限公司 | A kind of migration scheme of MySQL to KDB databases |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111400245A (en) * | 2020-03-25 | 2020-07-10 | 网易(杭州)网络有限公司 | Art resource migration method and device |
CN111400245B (en) * | 2020-03-25 | 2023-09-26 | 网易(杭州)网络有限公司 | Art resource migration method and device |
CN111462826A (en) * | 2020-04-09 | 2020-07-28 | 合肥本源量子计算科技有限责任公司 | Method for prompting quantum chemical simulation calculation progress, electronic equipment and storage medium |
CN111462826B (en) * | 2020-04-09 | 2023-04-28 | 合肥本源量子计算科技有限责任公司 | Method for prompting quantum chemistry simulation calculation progress, electronic equipment and storage medium |
TWI782487B (en) * | 2020-04-29 | 2022-11-01 | 香港商希瑞科技股份有限公司 | Method for performing simple storage service seamless migration using index objects, host device, and storage server |
US11509716B2 (en) | 2020-04-29 | 2022-11-22 | Silicon Motion Technology (Hong Kong) Limited | Method and apparatus for performing simple storage service seamless migration using index objects |
US11516287B2 (en) | 2020-04-29 | 2022-11-29 | Silicon Motion Technology (Hong Kong) Limited | Method and apparatus for performing simple storage service seamless migration using index objects |
CN111680023A (en) * | 2020-06-08 | 2020-09-18 | 中国银行股份有限公司 | Migration data checking method and device |
CN112000641A (en) * | 2020-07-31 | 2020-11-27 | 新华三大数据技术有限公司 | Data storage method, device and system |
CN112000641B (en) * | 2020-07-31 | 2022-08-30 | 新华三大数据技术有限公司 | Data storage method, device and system |
CN113297182A (en) * | 2021-06-16 | 2021-08-24 | 中国农业银行股份有限公司 | Data migration method, device, storage medium and program product |
CN113297182B (en) * | 2021-06-16 | 2024-01-30 | 中国农业银行股份有限公司 | Data migration method, device, storage medium and program product |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110659255A (en) | Data migration method, device and system and storage medium | |
US10885000B2 (en) | Repairing corrupted references | |
CN108132957B (en) | Database processing method and device | |
CN107315814B (en) | Method and system for verifying data consistency after data migration of KDB (KDB) database | |
CN106951369B (en) | Management method and device for joint debugging test | |
WO2018120721A1 (en) | Method and system for testing user interface, electronic device, and computer readable storage medium | |
CN107959579A (en) | The dispositions method and deployment system of multisystem | |
CN110460476B (en) | Network operation and maintenance management method | |
CN104317618A (en) | Firmware partitioning method and device | |
CN109086216B (en) | Automatic test system | |
CN107957712A (en) | The improved test manager for industrial automatic controller | |
CN107818029A (en) | A kind of cloud hard disc data recovers the automated testing method of uniformity | |
CN103197640A (en) | Intelligent management and control system and method of manufacturing technique | |
CN107870850A (en) | A kind of efficient the Internet, applications log system | |
WO2020028459A1 (en) | Method and system for implementing an automated data validation tool | |
CN108388623A (en) | ER relationships generation method, device, computer equipment and storage medium | |
EP4182788A1 (en) | Methods for software development and operation process analytics and devices thereof | |
CN113157336A (en) | C # language-based gripper configuration system, method, device and storage medium | |
CN109818825B (en) | Rack server intelligent test method and system | |
CN108959391B (en) | Apparatus, system, method, and storage medium for presenting database cluster architecture diagram | |
CN105607975A (en) | Method, device and system for testing disk arrays | |
CN107544830A (en) | A kind of method and device of automatic installation database | |
CN115509637A (en) | Form-based intelligent filling method, system, equipment and medium | |
CN114661715A (en) | Database data processing method and device, storage medium and electronic equipment | |
CN113239007B (en) | Multi-level heterogeneous log transaction analysis method, system, equipment and storage medium |
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 | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200107 |