发明名称 |
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. |
申请公布号 |
US2014379636(A1) |
申请公布日期 |
2014.12.25 |
申请号 |
US201313926236 |
申请日期 |
2013.06.25 |
申请人 |
Lober Andreas;Schierle Markus |
发明人 |
Lober Andreas;Schierle Markus |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A method of copying data in a table from a source database to a target database, the method 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. |
地址 |
Wiesloch DE |