Universal configurable database data migration method
A database and data technology, applied in the field of database data migration, can solve the problems of no common format definition for data description, lack of neutral data storage format, difficulty in ensuring accuracy, etc., to simplify data migration work, reduce labor costs, Guaranteed effect of accuracy
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Examples
Embodiment
[0092] There are two key points in this scheme: export the data in the source database as an XML-based data dump file, and import the XML-based data dump file into the destination database.
[0093] Export the data in the source database as an XML-based data dump file
[0094] Step 1: Parse the database information configuration file DB_INFO.xml and obtain the information required for the source database connection according to the source data ID.
[0095] Step 2: Analyze the data table information configuration file TABLE_INFO.xml, obtain the data table information and write the table information to the data dump file TABLE_DATA.xml, including table name and column name information.
[0096] Step 3: Connect to the source database, construct the sql required for data export according to the table structure information, and execute the sql for data query.
[0097] Step 4: Construct the data obtained from the query one by one into the format required by the value in TABLE_DATA ...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap