Claims
- 1. A method 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 method 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 the action type and of the unique key in a log table under the condition that the action type coincides with a predetermined action type; copying entries of the source table to the target table; and adjusting the entries in the target table that have keys represented in the log table according to the action type representation stored in the log table.
- 2. The method of claim 1 wherein copying entries comprises converting the coding of the entry.
- 3. The method of claim 2 wherein converting the coding of the entry comprises converting from a single-byte code to a multi-byte code.
- 4. The method of claim 3 wherein the single-byte code comprises ASCII-code and the double-byte code comprises unicode.
- 5. The method of claim 1 wherein adjusting the entries is performed in a first adjustment period while the application is sending database instructions and in a second adjustment period while the application is not sending database instructions.
- 6. The method of claim 1 wherein the predetermined action types are selected from the group consisting of insert, delete, and update.
- 7. The method of claim 1 wherein the database instructions are SQL statements.
- 8. The method of claim 1 wherein adjusting the entries comprises adjusting a first portion of the source table with a first portion of the target table substantially in parallel with adjusting a second portion of the source table with a second portion of the target table.
- 9. The method of claim 1 wherein copying entries comprises copying a first portion of the source table to a first portion of the target table substantially in parallel with copying a second portion of the source table to a second portion of the target table.
- 10. An article of manufacture comprising a computer readable 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 causing 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 the action type and of the unique key in a log table under the condition that the action type coincides with a predetermined action type; copying entries of the source table to the target table; and adjusting the entries in the target table that have keys represented in the log table according to the action type representation stored in the log table.
- 11. The article of claim 10 wherein copying entries comprises converting the coding of the entry.
- 12. The article of claim 11 wherein converting the coding of the entry comprises converting from a single-byte code to a multi-byte code.
- 13. The article of claim 12 wherein the single-byte code comprises ASCII-code and the double-byte code comprises unicode.
- 14. The article of claim 10 wherein adjusting the entries is performed in a first adjustment period while the application is sending database instructions and in a second adjustment period while the application is not sending database instructions.
- 15. The article of claim 10 wherein the predetermined action types are selected from the group consisting of insert, delete, and update.
- 16. The article of claim 10 wherein the database instructions are SQL statements.
- 17. The article of claim 10 wherein adjusting the entries comprises adjusting a first portion of the source table with a first portion of the target table substantially in parallel with adjusting a second portion of the source table with a second portion of the target table.
- 18. The article of claim 10 wherein copying entries comprises copying a first portion of the source table to a first portion of the target table substantially in parallel with copying a second portion of the source table to a second portion of the target table.
- 19. A computer program product 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, wherein prior to migrating, a business application consecutively sends database instructions to the source database, and wherein after migrating, the business application consecutively sends the database instructions to the target database, each table having entries corresponding to database instructions, each entry in each table having a unique key, and the database instructions having action types, the computer program product having instructions that cause a processor to perform operations comprising:
storing representations, for at least one entry in the source table, of the action type and of the unique key in a log table under the 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 the coding of each entry; and adjusting the entries in the target table that have keys represented in the log table according to the action type representation stored in the log table.
- 20. The computer program product of claim 19 wherein the instructions cause the processor to perform adjusting consecutively in a first adjustment period while the application is sending database instructions and in a second adjustment period while the application is not sending database instructions.
- 21. The computer program product of claim 19 wherein the instructions cause the processor to perform adjusting by adjusting a first portion of the source table with a first portion of the target table substantially in parallel to adjusting a second portion of the source table with a second portion of the target table.
- 22. 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:
means for 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; means for storing representations, for at least one entry in the source table, of the action type and of the unique key in a log table under the 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 the coding of each entry; and means for adjusting the entries in the target table that have keys represented in the log table according to the action type representation stored in the log table.
CROSS-REFERENCE TO RELATED APPLICATIONS
[0001] Under 35 U.S.C. § 120, this application is a continuation application of international application number PCT/EP01/06118 filed on May 30, 2001, and designating the U.S.
Continuations (1)
|
Number |
Date |
Country |
Parent |
PCT/EP01/06118 |
May 2001 |
US |
Child |
10714557 |
Nov 2003 |
US |