Our client has a system that is integrated to our Company application..the client system connects to Oracle database and our Company application connects to MySQL database.
The client side have given us a view on Oracle that has a set of 4 columns that resemble columns we have on our MySQL database.See below columns in Oracle database and their counterparts/equivalent in MySQL database.
Our client [ORACLE] | Our Company [MySQL]
[ORACLE] | [MYSQL]
AK_NO | Patient_File_Nr
BIL_NO | Invoice_Nr
PAYMENT_AMT | Amount
VOUCHER_DATE | Insert_Date
I am able to generate records present to each of the databases but then I am not able to figure out a way of getting records missing in either of the databases when doing a comparison check.
How would I write PHP code that connects to both databases and does query for records in MySQL that are not present in Oracle and vice-versa.
Copyright Notice：Content Author:「Joseph」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/7202387/challenge-in-getting-records-present-in-oracle-but-missing-in-mysql