Automated resolution of database dictionary conflicts

US9176996B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Andreas Lober · Wiesloch, DE
• Markus Schierle · Bad Rappenau, DE

Key dates

• Filing date: Jun 25, 2013
• Grant date: Nov 3, 2015
• Expiry date: Feb 21, 2034

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/258
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

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.