Data migration system and method

A technology for migrating systems and data, applied in database management systems, digital data processing, structured data retrieval, etc., can solve problems such as easy loss of migrated data, and achieve the effect of shortening failure recovery time and reducing log file size

Active Publication Date: 2017-04-19
SHANGHAI CTRIP COMMERCE CO LTD
View PDF3 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The technical problem to be solved by the present invention is to provide a data migration system and a data migration method in o

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data migration system and method
  • Data migration system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] The present invention is further illustrated below by means of examples, but the present invention is not limited to the scope of the examples.

[0040] Such as figure 1 As shown, the present embodiment provides a data migration system, the data migration system includes a source database 1, a migration server 3 and a target database 5, the source database 1 is provided with a migration intermediate table 2, and the server where the target database 5 is located is provided with Migration intermediate storehouse 6 is arranged, and migration step recording table 4 is provided in migration server 3, wherein, source database 1 and target database 5 are SQL Server databases, in the present embodiment, source database 1 and target database 5 communicate with each other through Internet respectively. Migrating the communication connection of the server 3, but corresponding adjustments can also be made according to the actual situation.

[0041] Before data migration, the migr...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a data migration system and method. The data migration system comprises a source database, a target database, and a migration server, wherein a migration middle table is arranged in the source database; a migration middle library is arranged in a server where the target database is located; the source database divides data to be migrated into N batches of the data, and imports each batch of the data into the migration middle table in sequence; the migration server imports the data to be migrated in the migration middle table into a data table of the migration middle library, and detects whether the data to be migrated in the migration middle table is identical to the data to be migrated in the data table of the migration middle library or not; and if the data to be migrated in the migration middle table is identical to the data to be migrated in the data table of the migration middle library, the migration middle library imports each batch of the data in the data table of the migration middle library into the target database in sequence. The system and method provided by the invention has the advantages that according to user requirements, the large-volume data can be automatically divided into the small-volume data for multiple cyclic migrations during data migration, so that the sizes of log files in the databases can be effectively reduced, and the failure recovery time can be shortened.

Description

technical field [0001] The invention relates to a data migration system and a data migration method. Background technique [0002] At present, based on SQL Server (a relational database management system launched by Microsoft) database, the commonly used data migration tools are Kettle (an open source ETL (data warehouse technology) tool) and SSIS (Microsoft SQLServer Integration Services, which generate high-performance Data integration solutions), etc., you can also use the data import and export tools that come with SQL Server. These tools have their own characteristics, but they all have the following problems: [0003] 1) It is not possible to perform small-batch circular migration of data, and only the entire data can be migrated at one time, resulting in a large log file of the database. If the database fails during the data migration process, the database recovery time will increase exponentially; [0004] 2) Errors are difficult to locate, the tool will only spew o...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
CPCG06F16/2255G06F16/25
Inventor 刘博郝国庆刘云
Owner SHANGHAI CTRIP COMMERCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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