Dynamic data discovery of a source data schema and mapping to a target data schema

摘要

A computerized method, program product, and a service that discovers trace data inserted into a source database having an unknown schema. Once the trace data is found by a dynamic data discovery engine, the tables, the fields, and the attributes of the fields in the source schema in which the trace data were located can be evaluated to determine if the data in the fields are pertinent to a target database. If so, then the data in those fields can be mapped and transferred to a target database. The dynamic data discovery engine generates the commands in both the source and the target database command language to find all pertinent data, map and transfer the data from the source database to a target database. The dynamic data discovery engine generates commands to create the target database and/or fields within an existing target database for the mapped and transferred data.