Database table copy

A computer system including a database copying tool configured to copy data records from a first table residing in a database to a second table, the database copying tool hosted on one or more networked computers, the database copying tool comprising:

• a copy controller;
• a database interface configured to provide the copy controller access to the database on which the first table resides;
• and
• a copy task generator configured to generate multiple instances of copying processes for copying data from the first table over to the second table,
• wherein the copy controller is configured to categorize or group data records in the first table into a multiplicity of parallel copy groups, and to copy the multiplicity parallel copy groups over to target table in parallel by using the corresponding multiplicity of parallel instances of the copying processes generated by copy task generator.

A computer-program product embodied in a non-transitory computer-readable medium that includes executable code, which when executed, causes a computer system to copy data records from a first table residing in a database to a second table by:

• selecting a column of the first table as a parallelization column;
• identifying a number of distinct data record field values in the parallelization column of the first table and identifying a corresponding number of copy groups of data records, each copy group of the data records including data records having the same distinct data record field value in the parallelization column of the first table;
• and
• setting up a corresponding number of copy processes, each copy process configured to copy a respective copy group of data records from the first table to the second table.