Change data capturing during an upgrade

A non-transitory computer-readable storage medium storing code representing instructions that when executed are configured to cause a processor to perform a process, the code comprising code to:

• generate a logging table corresponding with an original table targeted for an upgrade;
• generate a control table configured to store a version identifier for changes logged in the logging table;
• receive an indicator of a change to a record of the original table during execution of at least a portion of the upgrade of the original table;
• and
• store in the logging table a primary key identifying the record of the original table and the version identifier stored in the control table,
• wherein specifics of the change to the record of the original table associated with the primary key is excluded from the logging table.

A method including executing instructions recorded on a non-transitory computer-readable storage media using at least one processor, the method comprising:

• generating a logging table corresponding with an original table targeted for an upgrade,. the logging table including a first partition for logging changes to the original table during a first time period and a second partition for logging changes to the original table during a second time period;
• generating a control table configured to store a first version identifier for changes logged in the first partition of the logging table during the first time period, and a second version identifier for changes logged in the second partition of the logging table during the second time period;
• storing, in the first partition of the logging table, primary keys of records for the changes associated with the first version identifier during the first time period;
• storing, in the second partition of the logging table, primary keys of records for the changes associated with the second version identifier during the second time period;
• and
• transferring, from the first partition of the logging table, the changes associated with the first version identifier during the second time period during which the primary keys of records associated with the second version identifier are stored in the second partition.