Patent ID: 7647354

Claim:
A method for change data capture, comprising the steps of: copying a recovery log of a first system to a first object in a second system; storing the recovery log; obtaining change data from the recovery log stored in the first object based in-part on a column in the recovery log that holds data representing when a transaction has been committed; generating a SQL single multi-table insert statement to obtain the change data in a single transaction from a recovery log; grouping a plurality of change tables in a database of the second system into at least two groups of change tables; and executing an SQL statement wherein the SQL statement specifies inserting the change data into one of the at least two groups of change tables, where the change data is inserted into each of the change tables in the one of the at least two groups of change tables having a column corresponding to the column in the recovery log, and change data representing modifications that has been performed to a plurality of source tables in the database that correspond to the change table, wherein the obtaining and inserting is performed in a single transaction.