A system, method, and computer-readable medium for consolidating multiple databases into a single or a smaller number of databases is described. An improved structure of target database may be achieved by removing constraints used when creating legacy databases. According to some aspects, these and other benefits may be achieved by combining multiple source tables into a single target table with errors being identified and addressed during the creation of the instructions to generate the target table. In implementation, this may be effected by converting values from a source table and values from a target table into normalized versions of those values and then comparing the normalized values. A benefit includes verifying that the data from the source table is being properly reflected in the target table.