System and Method for Duplicating Structured Data in a Database

A computer-implemented method for duplicating data comprising:

• storing, by a data and content management server, a first change data record in a log table of the content management server, wherein the log table includes a first plurality of change data records associated with a document data type and a second plurality of change data records associated with an object data type, and wherein each change data record of the first plurality of change data records and the second plurality of change data records includes a timestamp;
• extracting, by the data and content management server, each change data record of the first plurality of change data records and the second plurality of change data records including a timestamp within a predetermined timeframe;
• generating, by the data and content management server, first flattened data including at least a portion of the extracted first plurality of change data records;
• generating, by the data and content management server, second flattened data including at least a portion of the extracted second plurality of change data records;
• selecting, by the data and content management server, a first extract file and a second extract file from a first repository of the data and content management server;
• creating, by the data and content management server, a third extract file based on the first extract file and the first flattened data but not the second flattened data;
• creating, by the data and content management server, a fourth extract file based on the second extract file and the second flattened data but not the first flattened data;
• creating, by the data and content management server, a data change file including the third extract file and the fourth extract file;
• and
• presenting, by the data and content management server, the data change file with an application programming interface (API) to enable access to the data change file.

A computer-implemented method for duplicating data comprising:

• storing, by a data and content management server, a first change data record in a log table of the content management server, wherein the log table includes a first plurality of change data records associated with a document data type and a second plurality of change data records associated with an object data type, and wherein each change data record of the first plurality of change data records and the second plurality of change data records includes a timestamp;
• extracting, by the data and content management server, each change data record of the first plurality of change data records and the second plurality of change data records including a timestamp within a predetermined timeframe;
• generating, by the data and content management server, first flattened data including at least a portion of the extracted first plurality of change data records;
• selecting, by the data and content management server, a first plurality of incremental extract files and a second plurality of incremental extract files from a first repository of the data and content management server;
• creating, by the data and content management server, a first full extract file based on the first plurality of incremental extract files and the first flattened data but not the second flattened data;
• generating, by the data and content management server, second flattened data including at least a portion of the extracted second plurality of change data records;
• creating, by the data and content management server, a second full extract file based on the second plurality of incremental extract files and the second flattened data but not the first flattened data;
• creating, by the data and content management server, a full data change file including the first full extract file and the second full extract file;
• and
• presenting, by the data and content management server, the data change file with an application programming interface (API) to enable access to the data change file.