Automated resolution of database dictionary conflicts

摘要

Copying data in a table from a source database to a target database is performed by copying the table into a conflicts schema. A first INSERT/SELECT statement is executed to copy data from the table. Then, in response to a determination that the table definition for the table in a source database dictionary is not compatible with a table definition for the table in a target database dictionary, the INSERT/SELECT statement execution is rolled back in response to a determination that the data from the first INSERT/SELECT statement did not fit in a table in the target schema of the target database. A second INSERT/SELECT statement is executed including a WHERE clause to copy data from the table 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 to the target schema of the target database, a third INSERT/SELECT statement is executed forcing the data to fit.

主权项

1. A method of copying data in a table from a source database to a target database, the method comprising:
copying, by one or more processors, data from the table in the source database into a conflicts schema; determining, by the one or more processors, 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, by the one or more processors 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.