Invention Grant
- Patent Title: Transport handling of foreign key checks
-
Application No.: US15983469Application Date: 2018-05-18
-
Publication No.: US10942892B2Publication Date: 2021-03-09
- Inventor: Volker Driesen , Wulf Kruempelmann
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/11
- IPC: G06F16/11

Abstract:
Implementations can include actions of, prior to executing a transport between a first and a second database system, receiving a set of records, and, for a first record: identifying a first table of the first database system that the first record is stored in, and determining that the first table is associated with a set of foreign key constraints (FKCs), and, for each FKC: determining that a referenced record exists based on a FKC, the FKC relating the first record in the first table to the referenced record in a second table, and selectively adding the referenced record to a list of the transport to maintain validity of the FKC within the second database system after execution of the transport, and providing the transport including the list, the transport being executable in the second database system to one or more of add records and delete records.
Public/Granted literature
- US20190354600A1 TRANSPORT HANDLING OF FOREIGN KEY CHECKS Public/Granted day:2019-11-21
Information query