US 12,147,400 B1
Relational database migration
Roger Everette Sanders, Fuquay Varina, NC (US); Martin G. Keen, Cary, NC (US); and Khwaja Jawahar Jahangir Shaik, Jacksonville, FL (US)
Assigned to INTERNATIONAL BUSINESS MACHINES CORPORATION, Amork, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Aug. 22, 2023, as Appl. No. 18/453,406.
Int. Cl. G06F 16/21 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/214 (2019.01) [G06F 16/27 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method of facilitating processing within a computing environment, the computer-implemented method comprising:
migrating a relational database of a source relational database management system to a target relational database of a target relational database management system, the migrating comprising:
identifying user-defined data objects of the relational database in the source relational database management system;
generating statements to recreate the identified user-defined data objects of the relational database in the target relational database management system, the statements including one set of statements to recreate one set of user-defined data objects at the target relational database prior to database data movement to the target relational database, and another set of statements to recreate another set of user-defined data objects at the target relational database after the database data movement to the target relational database; and
initiating execution of the one set of statements to recreate the one set of user-defined data objects of the relational database in the target relational database management system prior to the database data movement, while holding execution of the other set of statements to recreate the other set of user-defined data objects until after the database data movement to the target relational database.