Systems and methods for migrating database data

A computer program product, the computer program product being tangibly embodied on a computer-readable storage device storing instructions that when executed cause a processor to perform a process, the instructions comprising instructions to:

• create an image copy of data in a source database;
• collect metadata describing structural attributes of the source database;
• use the metadata to ensure a structure of the source database and a structure of a target database are compatible, including matching a name for a source table from the metadata with a name for a target table in the target database and determining that a value calculated based on columns included in the source table matches a value calculated based on columns included in the target table;
• and
• refresh data in the target database using the image copy of the data in the source database when the structure of the source database and the structure of the target database are compatible.

A computer system for migrating data from a source database to a target database comprising:

• a source computing system including:
• at least a first processor;
• a source database;
• and
• memory storing instructions that, when executed by the at least first processor, cause the source computing system to:
• create an image copy of data in the source database,
• create a file of metadata describing structural attributes of the source database;
• and
• a target computing system including:
• at least a second processor,
• a target database, and
• memory storing instructions that, when executed by the at least second processor, cause the target computing system to:
• use the file of metadata to ensure a structure of the source database and a structure of the target database are compatible, including, for each source table object in the metadata file, determining that a value calculated based on columns included in the source table object matches a value calculated based on columns included in a target table object, wherein when the values do not match the structure of the target database is not compatible with the structure of the source database,
• refresh data in the target database using the image copy of the data in the source database when the structure of the source database and the structure of the target database are compatible.