Configurable and incremental database migration framework for heterogeneous databases

Abstract

Various methods are provided for facilitating heterogeneous database migration. One example method may comprise accessing a migration configuration file, the migration configuration file comprising information indicative of at least a source database type of a source database, connection information of accessing the source database, a destination database type of a destination database, and connection information for accessing the destination database, generating configuration data based on the source database type and the destination database type to generate a mapping of a source database table stored within the source database to a destination database table stored within the destination database, and generating a query for execution on the source database enabling data migration from the source database to the destination database.

1 - 21 . (canceled) 
     
     
         22 . An apparatus comprising at least one processor and at least one non-transitory memory having computer-coded instructions stored thereon that, in execution with the at least one processor, cause the apparatus to:
 identify a migration configuration file associated with at least one source database and at least one destination database, wherein the migration configuration file comprises a first database type associated with the at least one source database and wherein the migration configuration file comprises a second database type associated with the at least one destination database, wherein the first database type differs from the second database type;   generate a plurality of queries based at least in part on the migration configuration file, wherein each query of the plurality of queries comprises a function for migration from at least a particular source database of the at least one source database to a particular destination database of the at least one destination database; and   execute the plurality of queries to perform migration from the at least one source database of the first database type to the at least one destination database of the second database type.   
     
     
         23 . The apparatus according to  claim 22 , wherein the at least one source database comprises a first plurality of different database types, and wherein the at least one destination database comprises a second plurality of different database types, wherein the plurality of queries comprises a query associated with migration from a first database type of the first plurality of different database types to a second database type of the second plurality of different database types, and wherein the plurality of queries comprises a second query associated with migration from a third database type of the first plurality of different database types to a fourth database type of the second plurality of different database types. 
     
     
         24 . The apparatus according to  claim 22 , the apparatus further caused to:
 maintain a function for each combination of a first plurality of possible database types associated with the at least one source database and a second plurality of possible database types associated with the at least one destination database.   
     
     
         25 . The apparatus according to  claim 22 , wherein the plurality of queries comprises at least a first query that migrates first data from a first source database of the at least one source database and second data from a second source database of the at least one source database to a first destination database of the at least one destination database, wherein the first source database and the second source database are different databases. 
     
     
         26 . The apparatus according to  claim 22 , wherein the plurality of queries comprises at least a first query that migrates first data from a first table of a first source database of the at least one source database and second data from a second table of a second source database of the at least one source database to a first table of a first destination database of the at least one destination database. 
     
     
         27 . The apparatus according to  claim 22 , the apparatus further caused to:
 identify at least one supporting function based at least in part on the first database type associated with the at least one source database and the second database type associated with the at least one destination database; and   process migration data utilizing the at least one supporting function before the migration data is migrated to the at least one destination database.   
     
     
         28 . The apparatus according to  claim 22 , wherein the apparatus accesses the at least one source database, the at least one destination database, or a combination of the at least one source database and the at least one destination database based at least in part on a connection file, and wherein the apparatus is further caused to:
 maintain the connection file in a separate storage location from the migration configuration file.   
     
     
         29 . A computer-implemented method comprising:
 identifying a migration configuration file associated with at least one source database and at least one destination database, wherein the migration configuration file comprises a first database type associated with the at least one source database and wherein the migration configuration file comprises a second database type associated with the at least one destination database, wherein the first database type differs from the second database type;   generating a plurality of queries based at least in part on the migration configuration file, wherein each query of the plurality of queries comprises a function for migration from at least a particular source database of the at least one source database to a particular destination database of the at least one destination database; and   executing the plurality of queries to perform migration from the at least one source database of the first database type to the at least one destination database of the second database type.   
     
     
         30 . The computer-implemented method according to  claim 29 , wherein the at least one source database comprises a first plurality of different database types, and wherein the at least one destination database comprises a second plurality of different database types, wherein the plurality of queries comprises a query associated with migration from a first database type of the first plurality of different database types to a second database type of the second plurality of different database types, and wherein the plurality of queries comprises a second query associated with migration from a third database type of the first plurality of different database types to a fourth database type of the second plurality of different database types. 
     
     
         31 . The computer-implemented method according to  claim 29 , the computer-implemented method further comprising:
 maintaining a function for each combination of a first plurality of possible database types associated with the at least one source database and a second plurality of possible database types associated with the at least one destination database.   
     
     
         32 . The computer-implemented method according to  claim 29 , wherein the plurality of queries comprises at least a first query that migrates first data from a first source database of the at least one source database and second data from a second source database of the at least one source database to a first destination database of the at least one destination database, wherein the first source database and the second source database are different databases. 
     
     
         33 . The computer-implemented method according to  claim 29 , wherein the plurality of queries comprises at least a first query that migrates first data from a first table of a first source database of the at least one source database and second data from a second table of a second source database of the at least one source database to a first table of a first destination database of the at least one destination database. 
     
     
         34 . The computer-implemented method according to  claim 29 , the computer-implemented method further comprising:
 identifying at least one supporting function based at least in part on the first database type associated with the at least one source database and the second database type associated with the at least one destination database; and   processing migration data utilizing the at least one supporting function before the migration data is migrated to the at least one destination database.   
     
     
         35 . The computer-implemented method according to  claim 29 , the computer-implemented method further comprising:
 accessing the at least one source database, the at least one destination database, or a combination of the at least one source database and the at least one destination database based at least in part on a connection file; and   maintaining the connection file in a separate storage location from the migration configuration file.   
     
     
         36 . A computer program product comprising at least one non-transitory computer-readable storage medium having computer code stored thereon that, in execution with at least one processor, configures the computer program product for:
 identifying a migration configuration file associated with at least one source database and at least one destination database, wherein the migration configuration file comprises a first database type associated with the at least one source database and wherein the migration configuration file comprises a second database type associated with the at least one destination database, wherein the first database type differs from the second database type;   generating a plurality of queries based at least in part on the migration configuration file, wherein each query of the plurality of queries comprises a function for migration from at least a particular source database of the at least one source database to a particular destination database of the at least one destination database; and   executing the plurality of queries to perform migration from the at least one source database of the first database type to the at least one destination database of the second database type.   
     
     
         37 . The computer program product according to  claim 36 , wherein the at least one source database comprises a first plurality of different database types, and wherein the at least one destination database comprises a second plurality of different database types, wherein the plurality of queries comprises a query associated with migration from a first database type of the first plurality of different database types to a second database type of the second plurality of different database types, and wherein the plurality of queries comprises a second query associated with migration from a third database type of the first plurality of different database types to a fourth database type of the second plurality of different database types. 
     
     
         38 . The computer program product according to  claim 36 , the computer program product further configured for:
 maintaining a function for each combination of a first plurality of possible database types associated with the at least one source database and a second plurality of possible database types associated with the at least one destination database.   
     
     
         39 . The computer program product according to  claim 36 , wherein the plurality of queries comprises at least a first query that migrates first data from a first source database of the at least one source database and second data from a second source database of the at least one source database to a first destination database of the at least one destination database, wherein the first source database and the second source database are different databases. 
     
     
         40 . The computer program product according to  claim 36 , wherein the plurality of queries comprises at least a first query that migrates first data from a first table of a first source database of the at least one source database and second data from a second table of a second source database of the at least one source database to a first table of a first destination database of the at least one destination database. 
     
     
         41 . The computer program product according to  claim 36 , the computer program product further configured for:
 identifying at least one supporting function based at least in part on the first database type associated with the at least one source database and the second database type associated with the at least one destination database; and   processing migration data utilizing the at least one supporting function before the migration data is migrated to the at least one destination database.