关系数据迁移方法、装置、设备及存储介质

By creating a new export task in the source system, the system automatically associates and migrates objects and their dependent data, and generates insert or update statements in the target system. Combined with pre-imported libraries and backup files, this solves the problem of inconvenience in migrating relational data in multi-environment systems, and achieves efficient and secure data migration.

CN116136841BActive Publication Date: 2026-07-17GLODON CO LTD

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
GLODON CO LTD
Filing Date
2023-02-23
Publication Date
2026-07-17

AI Technical Summary

Technical Problem

In existing technologies, the migration of relational data between different systems is inconvenient and difficult, especially in physically isolated multi-environment systems, where manual migration is labor-intensive and it is difficult to achieve fast and accurate data migration.

Method used

This paper provides a relational data migration method. By creating an export task in the source system, the method automatically identifies and associates the relational data of the exported object and its dependent objects, and migrates it to the target system. The method uses object type to configure the dependency relationship, generates insert or update statements for data import, and combines pre-imported libraries and backup files to ensure data accuracy and security.

Benefits of technology

It enables autonomous selection of migration data and automatic association, improving the convenience and accuracy of data migration and ensuring the security and consistency of the data migration process.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116136841B_ABST
    Figure CN116136841B_ABST
Patent Text Reader

Abstract

本申请是关于一种关系数据迁移方法、装置、设备及存储介质,具体涉及计算机信息技术领域。该方法包括:响应于导出任务创建操作,在源系统中新建导出任务;响应于对象选择操作,从对象集合中确定出导出对象,并确定所述导出对象的依赖对象,所述对象集合中包括所述源系统中源数据库对应的所有对象,每个对象对应所述源数据库中的一条关系数据,所述依赖对象对应的关系数据用于描述所述导出对象对应的关系数据;从所述源数据库中查询所述导出对象、所述导出对象的依赖对象对应的关系数据,将查询到的关系数据作为迁移内容导入到目标系统中的目标数据库。基于本技术方案,可以实现自主选择迁移数据以及迁移数据的自动关联,提高数据迁移的便捷性。
Need to check novelty before this filing date? Find Prior Art