Automated resolution of database dictionary conflicts

A system comprising:

• a source database in a memory;
• a target database;
• a database management system executable by one or more processors configured to:
• copy data from the table in the source database into a conflicts schema;
• determine whether a table definition for the table in the source database dictionary is compatible with a table definition for the table in a target database dictionary;
• execute a first INSERT/SELECT statement to copy data from the table in the conflicts schema to a target schema of the target database;
• in response to a determination that the table definition for the table in the source database dictionary is not compatible with the table definition for the table in the target database dictionary:
• roll back the first INSERT/SELECT statement execution in response to a determination that the data from the first INSERT/SELECT statement did not fit in the table in the target schema of the target database;
• execute a second INSERT/SELECT statement including a WHERE clause to copy data from the table in the conflicts schema to the target schema of the target database;
• in response to a determination that the second INSERT/SELECT statement did not copy data from the table in the conflicts schema to the target database, execute a third INSERT/SELECT statement forcing the data to fit in the table in the target schema of target database.

A non-transitory computer-readable storage medium comprising instructions that, when executed by at least one processor of a machine, cause the machine to perform operations of copying data in a table from a source database to a target database, the operations comprising:

• copying data from the table in the source database into a conflicts schema;
• determining whether a table definition for the table in the source database dictionary is compatible with a table definition for the table in a target database dictionary;
• executing a first INSERT/SELECT statement to copy data from the table in the conflicts schema to a target schema of the target database;
• in response to a determination that the table definition for the table in the source database dictionary is not compatible with the table definition for the table in the target database dictionary:
• rolling back the first INSERT/SELECT statement execution in response to a determination that the data from the first INSERT/SELECT statement did not fit in the table in the target schema of the target database;
• executing a second INSERT/SELECT statement including a WHERE clause to copy data from the table in the conflicts schema to the target schema of the target database;
• in response to a determination that the second INSERT/SELECT statement did not copy data from the table in the conflicts schema to the target database, executing a third INSERT/SELECT statement forcing the data to fit in the table in the target schema of target database.