Method, system, and computer program for migrating content from source database to target database

An article of manufacture comprising a computer readable storage medium having computer readable program code embodied therein for executing instructions for migrating content from a source table in a source database to a target table in a target database, wherein the databases are physically different, the instructions adapted to cause a processor to perform operations comprising:

• storing entries corresponding to database instructions in at least one of the source table and the target table, with a business application consecutively sending database instructions to the source database before migrating, the business application consecutively sending database instructions to the target database after migrating, each entry in each table having a unique key, and the database instructions having action types;
• storing representations, for at least one entry in the source table, of an action type and of the unique key in a log table under a condition that the action type coincides with a predetermined action type;
• copying entries of the source table to the target table;
• removing representations from the log table of the entries copied from the source table to the target table;
• adjusting the entries in the target table that have keys represented in the log table according to the action type representations stored in the log table;
• and
• removing representations from the log table of the entries adjusted in the target table,
• wherein copying the entries comprises converting a coding of each entry, and
• wherein adjusting the entries is performed in a first adjustment period while the business application is sending database instructions and in a second adjustment period while the business application is not sending database instructions.

A computer program product embodied on a computer-readable storage medium for migrating content from a source table in a source database to a target table in a target database, wherein the databases are physically different, the computer program product having instructions adapted to cause a processor to perform operations comprising:

• storing entries corresponding to database instructions in at least one of the source table and the target table, with a business application consecutively sending database instructions to the source database before migrating, the business application consecutively sending database instructions to the target database after migrating, each table having entries corresponding to database instructions, each entry in each table having a unique key, and the database instructions having action types;
• storing representations, for at least one entry in the source table, of an action type and of the unique key in a log table under a condition that the action type coincides with a predetermined action type;
• copying entries of the source table to the target table, wherein copying entries includes converting a coding of each entry;
• removing representations from the log table of the entries copied from the source table to the target table;
• adjusting the entries in the target table that have keys represented in the log table according to the action type representations stored in the log table;
• and
• removing representations from the log table of the entries adjusted in the target table, wherein the instructions cause the processor to perform adjusting consecutively in a first adjustment period while the business application is sending database instructions and in a second adjustment period while the business application is not sending database instructions.

A computer system for migrating content from a source table in a source database to a target table in a target database, wherein the databases are physically different, the computer system having a migration tool comprising:

• a computer-readable storage medium;
• means for storing in the computer-readable storage medium entries corresponding to database instructions in at least one of the source table and the target table, with a business application consecutively sending database instructions to the source database before migrating, the business application consecutively sending database instructions to the target database after migrating, each entry in each table having a unique key, and the database instructions having action types;
• means for storing in the computer-readable storage medium representations, for at least one entry in the source table, of an action type and of the unique key in a log table under a condition that the action type coincides with a predetermined action type;
• means for copying entries of the source table to the target table, wherein copying entries includes converting a coding of each entry;
• means for removing representations from the log table of the entries copied from the source table to the target table;
• means for adjusting the entries in the target table that have keys represented in the log table according to the action type representations stored in the log table;
• and
• means for removing representations from the log table of the entries adjusted in the target table, wherein means for adjusting the entries in the target table further adjusts the entries in the target table in a first adjustment period while the business application is sending database instructions and in a second adjustment period while the business application is not sending database instructions.