A system comprising at least one hardware-based processor and memory, wherein the memory comprises processor-executable instructions encoded on a non-transient processor-readable media, wherein the processor-executable instructions, when executed by the hardware-based processor, are configurable to cause:
- querying a source database to collect partition metadata information comprising:
- a first set of the partition metadata information for a first set of partitions from a source database that are to be copied to a first target database, and a second set of the partition metadata information for a second set of partitions from the source database that are to be copied to a second target database;
- creating, based on the partition metadata information, at least one extent chunk for each partition of a table;
- querying the source database for a first set of data based on a first set of extent chunks, and a second set of data based on a second set of extent chunks;
- and
- writing the first set of data to the first target database, and the second set of data to the second target database.