Method, system, and program product for migrating data from one data base management system to another data base management system

Abstract

A method, system, and program product to migrate data from a data table in a data source to a data table in a target. This is done initiating processes, typically two parallel batch processes, with one of the processes unloading the data from the data source and uploading the data into the data target, and the other of the processes loading the source data into a database at the data target. Preferably the processes are parallel batch process. The processes are initiated from the data target.

We claim:  
     
         1 . A method of migrating data from a table in a source system to a table in a target system comprising the steps of: 
 a. initiating two parallel batch processes,    b. one of said batch processes unloading the data from the source system and uploading the data into the target system, and    c. the other of said batch processes loading the source data into a database table at the target system.    
     
     
         2 . The method of  claim 1  comprising using an SQL “SELECT * FROM tablename” command to unload the data from the source system, where “tablename” is the name of the source table.  
     
     
         3 . The method of  claim 1  comprising using a LOAD Utility to load the data into a database at the target system.  
     
     
         4 . The method of  claim 1  comprising 
 a. initiating the two parallel batch processes on the target system,  
 b. first initiating the said batch process to load the source data into a database at the target system; and  
 c. thereafter initiating the other of one of said batch processes to unload the data from the source system and uploading the data into the target system.  
 
     
     
         5 . The method of  claim 1  wherein the tables are relational database tables.  
     
     
         6 . The method of  claim 1  comprising generating on the target system control languages to submit and execute batch jobs for data transfer.  
     
     
         7 . A computer system comprising at least one database management system configured and controlled as a target system and adapted for communication with a second database management system functioning as a source system, said computer system comprising at least one database management system configured and controlled as a target system, said computer system being further configured and controlled to execute two batch processes from the target system, 
 a. one of said batch processes unloading data from the source system and uploading the data to the target system, and    b. the other of said batch processes loading the data into a database at the target system.    
     
     
         8 . The system of  claim 7  comprising using an SQL “SELECT * FROM tablename” command to unload the data from the source system, where “tablename” is the name of the source table.  
     
     
         9 . The system of  claim 7  comprising using a LOAD Utility to load the source data into a database at the target system.  
     
     
         10 . The system of  claim 7  further adapted to: 
 a. initiate the two parallel batch processes on the target system,  
 b. first initiate the said batch process to load the data into a database at the target system; and  
 c. thereafter initiate the other of one of said batch processes to unload the data from the source system and upload the data into the target system.  
 
     
     
         11 . The system of  claim 7  wherein the tables are relational database tables.  
     
     
         12 . The system of  claim 7  further adapted and controlled to generate on the target system control languages to submit and execute batch jobs for data transfer.  
     
     
         13 . A program product comprising computer readable instructions on a media, said instructions being capable of controlling and configuring a computer to carry out the method of migrating data from a data base in a source system to a data base in a target system and comprising the steps of: 
 a. initiating two parallel batch processes,    b. one of said batch processes unloading data from the source system and uploading the data to the target system, and    c. the other of said batch processes loading the data into a data table at the target system.    
     
     
         14 . The program product of  claim 13  wherein the program product further comprises computer readable instructions for using an SQL “SELECT * FROM tablename” command to unload the data from the source system, where “tablename” is the name of the source table.  
     
     
         15 . The program product of  claim 13  wherein the program product further comprises computer readable instructions for using a LOAD Utility to load the data into the table at the target system.  
     
     
         16 . The program product of  claim 13  wherein the media is magnetic or optical media.  
     
     
         17 . The program product of  claim 13  wherein the computer readable instructions are readable for at least one of transmission, installation, instantiation, or execution.  
     
     
         18 . The program product of  claim 13  wherein the computer readable instructions are in the form of executable code.  
     
     
         19 . The program product of  claim 13  wherein the computer readable instructions are in the form of code that requires loading to memory for execution.  
     
     
         20 . The program product of  claim 13  wherein the computer readable instructions are in the form of distribution code that requires one of both of decompression or decryption to be executable.  
     
     
         21 . The program product of  claim 13  further containing instructions to: 
 a. initiate the two parallel batch processes on the target system,  
 b. first initiate the said batch process to load the data into a database at the target system; and  
 c. thereafter initiate the other of one of said batch processes to unload the data from the source system and upload the data into the target system.  
 
     
     
         22 . The program product of  claim 13  wherein the tables are relational database tables.  
     
     
         23 . The program product of  claim 13  further containing instructions to generate on the target system control languages to submit and execute batch jobs for data transfer.  
     
     
         24 . A program product comprising computer readable instructions on a media, said instructions being capable of controlling and configuring a computer to carry out the method of migrating data from a data base in a source system to a data base in a target system and comprising the steps of: 
 a. initiating two processes on the target system,    b. one of said processes unloading data from the source system and uploading the data to the target system, and    c. the other of said processes loading the data into a table at the target system.    
     
     
         25 . The method of  claim 24  wherein the processes are parallel processes.  
     
     
         26 . The method of  claim 24  wherein the processes are batch processes.  
     
     
         27 . The program product of  claim 24  wherein the program product further comprises computer readable instructions for using an SQL “SELECT * FROM tablename” command to unload the data from the source system, where “tablename” is the name of the source table.  
     
     
         28 . The program product of  claim 24  wherein the program product further comprises computer readable instructions for using a LOAD Utility to load the data into a table at the target system.  
     
     
         29 . The program product of  claim 24  wherein the media is magnetic or optical media.  
     
     
         30 . The program product of  claim 24  wherein the computer readable instructions are readable for at least one of transmission, installation, instantiation, or execution.  
     
     
         31 . The program product of  claim 24  wherein the computer readable instructions are in the form of executable code.  
     
     
         32 . The program product of  claim 24  wherein the computer readable instructions are in the form of code that requires loading to memory for execution.  
     
     
         33 . The program product of  claim 24  wherein the computer readable instructions are in the form of distribution code that requires one of both of decompression or decryption to be executable.  
     
     
         34 . The program product of  claim 24  further containing instructions to: 
 a. initiate the two parallel batch processes on the target system,  
 b. first initiate the said batch process to load the data into a database at the target system; and  
 c. thereafter initiate the other of one of said batch processes to unload the data from the source system and upload the data into the target system.  
 
     
     
         35 . The program product of  claim 24  wherein the tables are relational database tables.  
     
     
         36 . The program product of  claim 24  further containing instructions to generate on the target system control languages to submit and execute batch jobs for data transfer.