Data migration system and method

• US 7,313,560 B2
• Filed: 12/09/2002
• Issued: 12/25/2007
• Est. Priority Date: 12/09/2002
• Status: Active Grant

• Current Assignee: Daedalus Blue LLC
• Original Assignee: International Business Machines Corporation
• Inventors: Dilley, Reginald James Jr., Keimig, Mark A., Nagel, Lynn N., Orb, Walter
• Primary Examiner(s): An, Meng-Al T.
• Assistant Examiner(s): Truong, Camquy
• Application Number:
  US10/314,583
• Publication Number:
  US 20040111726A1
• Time in Patent Office: 1,842 Days
• Field of Search: 718/102, 107204-205, 707/100, 707/204
• US Class Current: 1/1
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A system and method for migrating data from a source system to a target system using a heterogeneous set of migration systems. The described system comprises: a plurality of migration systems, wherein each migration system includes a set of processes for migrating data; and a scheduling system for scheduling processes associated with each of the plurality of migration systems to provide concurrent operation of the plurality of migration systems.

Claims

1. A system for migrating data from a source system to a target system, comprising:

a processor, and

a memory, the memory having;

a plurality of migration systems, wherein each migration system includes a set of processes for migrating data; and

a scheduling system for scheduling processes associated with each of the plurality of migration systems to provide concurrent operation of the plurality of migration systems to migrate multiple portions of the data having identical initial formats,

wherein the plurality of migration systems include an SQL upload/download system,

wherein the SQL upload/download system includes an SQL unload process for unloading data from the source system to a first flat file within the source system, and wherein the first flat file is monitored by a monitoring system that is in communication with the scheduling system, and

wherein the scheduling system causes an FTP transfer to occur from the first flat file to a second flat file on the target system when the monitoring system detects that a predetermined amount of data has been uploaded to the first flat file.

2. The system of claim 1, wherein the scheduling system schedules an SQL load from the second flat file to a target database after the predetermined amount of data has been transferred to the second flat file.

3. The system of claim 1, wherein the predetermined amount of data comprises a group of tables.

4. The system of claim 1, wherein the plurality of migration systems includes an export/import system that uses named pipes to migrate data.

5. The system of claim 1, wherein the plurality of migration systems includes a create table as select system for migrating tables that do not include a predetermined restriction.

6. The system of claim 1, wherein the source system includes a source database having a plurality of tables, and wherein the scheduler assigns a migration system for each table based on at least one characteristic of the table.

7. The system of claim 6, wherein the at least one characteristic of the table is a size of the table.

8. The system of claim 1, wherein the scheduler includes a monitoring system that comprehensively monitors for errors and process completions for processes associated with each of the plurality of migration systems.

9. The system of claim 1, wherein the scheduler sets a priority for each process for each of the plurality of migration systems.

10. The system of claim 1, wherein the scheduler identifies failed processes and initiates a recovery and restart operation for failed processes.

11. The system of claim 1, wherein the scheduler tracks the number of processes running to manage resources for the target system.