CN115563088B - 不同类型的数据库的数据迁移方法及迁移系统 - Google Patents
不同类型的数据库的数据迁移方法及迁移系统 Download PDFInfo
- Publication number
- CN115563088B CN115563088B CN202211569603.4A CN202211569603A CN115563088B CN 115563088 B CN115563088 B CN 115563088B CN 202211569603 A CN202211569603 A CN 202211569603A CN 115563088 B CN115563088 B CN 115563088B
- Authority
- CN
- China
- Prior art keywords
- data
- sql
- value
- database
- client
- 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 45
- 238000013508 migration Methods 0.000 title claims abstract description 31
- 230000005012 migration Effects 0.000 title claims abstract description 31
- 230000005540 biological transmission Effects 0.000 claims abstract description 41
- 238000012216 screening Methods 0.000 claims abstract description 26
- 230000010076 replication Effects 0.000 claims description 12
- 238000006243 chemical reaction Methods 0.000 claims description 8
- 230000008859 change Effects 0.000 claims description 7
- 238000004891 communication Methods 0.000 claims description 4
- 238000004458 analytical method Methods 0.000 claims description 3
- 230000015572 biosynthetic process Effects 0.000 abstract 1
- 238000012545 processing Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000000873 masking effect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/12—Network monitoring probes
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (6)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211569603.4A CN115563088B (zh) | 2022-12-08 | 2022-12-08 | 不同类型的数据库的数据迁移方法及迁移系统 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211569603.4A CN115563088B (zh) | 2022-12-08 | 2022-12-08 | 不同类型的数据库的数据迁移方法及迁移系统 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN115563088A CN115563088A (zh) | 2023-01-03 |
CN115563088B true CN115563088B (zh) | 2023-07-25 |
Family
ID=84769881
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202211569603.4A Active CN115563088B (zh) | 2022-12-08 | 2022-12-08 | 不同类型的数据库的数据迁移方法及迁移系统 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN115563088B (zh) |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU2002950216A0 (en) * | 2002-07-11 | 2002-09-12 | Winluck Pty. Limited | Universal database application |
CN111859426A (zh) * | 2020-07-21 | 2020-10-30 | 西安电子科技大学 | 一种通用加密数据库连接器及其设置方法 |
CN115408370A (zh) * | 2022-10-26 | 2022-11-29 | 本原数据(北京)信息技术有限公司 | 数据库迁移评估方法和系统、计算机设备、存储介质 |
Family Cites Families (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103440273B (zh) * | 2013-08-06 | 2016-08-24 | 北京航空航天大学 | 一种数据跨平台迁移方法及装置 |
CN107423452A (zh) * | 2017-09-02 | 2017-12-01 | 国网辽宁省电力有限公司 | 一种电网异构数据库同步复制迁移方法 |
KR101917806B1 (ko) * | 2017-12-22 | 2018-11-12 | 주식회사 웨어밸리 | Sql 패킷분석을 통한 이기종 데이터베이스의 데이터 복제 및 동기화 오류 탐지 방법 및 시스템 |
US11030166B2 (en) * | 2018-11-22 | 2021-06-08 | Accenture Global Solutions Limited | Smart data transition to cloud |
US11741380B2 (en) * | 2020-01-31 | 2023-08-29 | Oracle International Corporation | Machine learning predictions for database migrations |
-
2022
- 2022-12-08 CN CN202211569603.4A patent/CN115563088B/zh active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU2002950216A0 (en) * | 2002-07-11 | 2002-09-12 | Winluck Pty. Limited | Universal database application |
CN111859426A (zh) * | 2020-07-21 | 2020-10-30 | 西安电子科技大学 | 一种通用加密数据库连接器及其设置方法 |
CN115408370A (zh) * | 2022-10-26 | 2022-11-29 | 本原数据(北京)信息技术有限公司 | 数据库迁移评估方法和系统、计算机设备、存储介质 |
Also Published As
Publication number | Publication date |
---|---|
CN115563088A (zh) | 2023-01-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP6668442B2 (ja) | Sqlパケット分析を通じての異機種データベースのデータ複製および同期化エラー探知方法およびシステム | |
US11132248B2 (en) | Automated information technology system failure recommendation and mitigation | |
WO2022063284A1 (zh) | 数据同步方法、装置、设备及计算机可读介质 | |
CN111949633B (zh) | 一种基于并行流处理的ict系统运行日志分析方法 | |
CN109034993A (zh) | 对账方法、设备、系统及计算机可读存储介质 | |
EP3396555B1 (en) | Method and system for automated enterprise testing system | |
US8560502B2 (en) | Method and a system for replaying database workload with transactional consistency | |
US20100274768A1 (en) | De-duplication and completeness in multi-log based replication | |
CN109656999B (zh) | 大数据量的数据同步方法、设备、存储介质及装置 | |
WO2018120720A1 (zh) | 客户端程序的测试错误定位方法、电子装置及存储介质 | |
CN102968374A (zh) | 一种数据仓库测试方法 | |
US20180349250A1 (en) | Content-level anomaly detector for systems with limited memory | |
US9998544B2 (en) | Synchronization testing of active clustered servers | |
CN113242157B (zh) | 一种分布式处理环境下的集中式数据质量监测方法 | |
CN112214411A (zh) | 一种容灾系统测试方法、装置、设备及存储介质 | |
CN111708673A (zh) | 一种日志数据压缩方法、装置、设备和存储介质 | |
US9047354B2 (en) | Statement categorization and normalization | |
CN113127520A (zh) | 一种基于代理模式的分布式数据库sql审核拦截方法及装置 | |
CN109902070B (zh) | 一种面向WiFi日志数据的解析存储搜索方法 | |
CN109992476B (zh) | 一种日志的分析方法、服务器及存储介质 | |
CN115563088B (zh) | 不同类型的数据库的数据迁移方法及迁移系统 | |
KR101191832B1 (ko) | 네트워크 패킷 분석을 통한 데이터베이스 복제 방법 및 시스템 | |
CN112256674A (zh) | 一种数据迁移方法、装置、电子设备和存储介质 | |
JP2021140430A (ja) | データベースマイグレーション方法、データベースマイグレーションシステム、及びデータベースマイグレーションプログラム | |
US8429458B2 (en) | Method and apparatus for system analysis |
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 | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20240308 Address after: D6-7, Aole Zhaoqi Town Cultural Industry Park, Etuoqueqian Banner, Ordos City, Inner Mongolia Autonomous Region, 016200 Patentee after: Inner Mongolia Zhengxinyun Technology Service Co.,Ltd. Country or region after: China Address before: No. 152, Zhongsan Road, Shiwan Town, Foshan, Guangdong 528000 Patentee before: GUANGDONG EFLYCLOUD COMPUTING Co.,Ltd. Country or region before: China |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20240511 Address after: 277000 No. 10, Jiefang South Road, Yicheng Economic Development Zone, Zaozhuang City, Shandong Province (room 8409, Yicheng headquarters economic center) Patentee after: Shandong Yunxiang sky Technology Service Co.,Ltd. Country or region after: China Address before: D6-7, Aole Zhaoqi Town Cultural Industry Park, Etuoqueqian Banner, Ordos City, Inner Mongolia Autonomous Region, 016200 Patentee before: Inner Mongolia Zhengxinyun Technology Service Co.,Ltd. Country or region before: China |