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

US7461097B2 · kind B2 · utility

Assignee

• SAP AG · DE

Inventors

• Martin Stahl · Kaltenkirchen, DE
• Bernd Kohler · Obertshausen, DE
• Guenter Briam · Wiesloch, DE
• Torsten Ziegler · Dielheim, DE
• Frank-Martin Haas · Wiesloch, DE

Key dates

• Filing date: Nov 14, 2003
• Grant date: Dec 2, 2008
• Expiry date: Jul 11, 2025

Classification

• Technology area (CPC Y): Emerging Cross-Sectional Technologies
• CPC primary: Y10S707/99952
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

In a software system (200/210/220) with a business application (200), database migration from a source database (210) to a physically different target database (230) is performed by a migration tool (260) that evaluates database instructions (201) that the application (200) consecutively sends to the source database (210). The migration tool (260) stores representations (254, 255) of an action type (205, D, I, U) and of a key (231) in a log table (250) when an action type coincides with a predetermined action type (D, I, U); copies source table entries to the target table (240); and adjusts entries in the target table that have keys represented in the log table (250). During migration, the application (200) and the source table continue communicating.