Oracle International Corporation

Barry McGillin

Chandrasekharan Iyer

Kristopher Leland Rice

Robert Pang

Dermot O'neill

A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system configures a communication session to intercept the foreign SQL statements before the foreign SQL statements are received by the SQL parser of the native database system; and, while the foreign application is waiting for query results, the system translates the foreign dialect query statements into native SQL compatible with the native database system. The method further performs translating a return code from the native database system into a return code compatible with the foreign application. Configuring the database session connection comprises establishing a translation profile to translate foreign dialect SQL into native SQL, and to translate native SQL query return codes into foreign dialect return codes.

Run-time SQL language translation

Systems, methods, and other embodiments associated with application source code scanning for database migration are described. In one embodiment, a method includes identifying a subset of application source code files that are likely to require modification to access a destination database. The subset of application source code files is scanned for artifact expressions that access a source database and should be changed to access the destination database.

Growing community of inventors

Northern Ireland, United Kingdom

Barry McGillin