INSERT INTO `test`.`transactions` (`T_ID`,`CustomerNO`,`BeneficiaryID`,`Date`,`Time`,`Acc_Name`,`Bank_Name`,`Bank_Code`,`Branch_Name`,`Branch_Code`,`Acc_No`,`AmountLKR`,`Agent`,`Status`,`Msg`,`Pdf`,`AmountAUD`) SELECT `id`,`CustomerNO`,`BeneficiaryID`,`date`,`time`,`name`,`bank`,`Bank_Code`,`branch`,`Branch_Code`,`ac`,`amount`,`location`,`status`,`msg`,`pdf`,`AmountAUD` FROM `cashexpr_cashexpress`.`transactions` INSERT INTO `test`.`customer` (`CustomerNO`,`CUserName`,`CPassWord`,`Title`,`Full_Name`,`Name_with_Initials`,`Date_Of_Birth`,`Gender`,`Occupation`,`Mobile_Ph`,`Home_Ph`,`Work_Ph`,`Fax_No`,`Residential_Street_No`,`Residential_Street_Name`,`Residential_Suburb`,`Residential_Post_Code`,`Residential_State`,`Residential_Country`,`ID_Type`,`ID_No`,`ID_Expiry`,`Issuer`,`Place_of_Issue`,`IDCopy`,`IDCopyImage`,`AccStatus`,`Email`,`IP`) SELECT `CustomerNO`,`username`,`password`,`Title`,`First_Name`,`Last_Name`,`Date_Of_Birth`,`Gender`,`Occupation`,`Mobile_Ph`,`Home_Ph`,`Work_Ph`,`Fax_No`,`Residential_Street_No`,`Residential_Street_Name`,`Residential_Suburb`,`Residential_Post_Code`,`Residential_State`,`Residential_Country`,`ID_Type`,`ID_No`,`ID_Expiry`,`Issuer`,`Place_of_Issue`,`idcopy`,`idcopyimage`,`acstatus`,`Email`,`IP` FROM `cashexpr_cashexpress`.`customer` INSERT INTO `test`.`ben` (`BeneficiaryID`,`CustomerNO`,`Benificiary_Full_Name`,`Acc_Name`,`Benificiary_Mobile_No`,`Benificiary_Home_Ph`,`Bank_Name`,`Bank_Code`,`Branch_Name`,`Branch_Code`,`Acc_No`,`Benificiary_ID_Type`,`Benificiary_IDN`,`Benificiary_Address`,`Benificiary_Town`,`Benificiary_Country`) SELECT `ID`,`CustomerNO`,`Benificiary_Last_Name`,`Benificiary_Other_Names`,`Benificiary_Mobile_No`,`Benificiary_Home_Ph`,`Bank`,`Bank_Code`,`Branch`,`Branch_Code`,`Account_NO`,`Benificiary_ID_Type`,`Benificiary_IDN`,`Benificiary_Address`,`Benificiary_Town`,`Benificiary_Country` FROM `cashexpr_cashexpress`.`ben` INSERT INTO `test`.`customerorders` (`OrderID`,`Date`,`Time`,`CustomerNO`,`BeneficiaryID`,`Acc_Name`,`Bank_Name`,`Bank_Code`,`Branch_Name`,`Branch_Code`,`Acc_No`,`AmountAUD`,`DepositMode`,`Agent`,`Msg`,`AmountLKR`,`Status`) SELECT `id`,`date`,`time`,`CustomerNO`,`BeneficiaryID`,`name`,`bank`,`Bank_Code`,`branch`,`Branch_Code`,`ac`,`AmountAUD`,`deposit`,`Location`,`msg`,`amount`,`status` FROM `cashexpr_cashexpress`.`customerorders` INSERT INTO `test`.`funds` (`FID`,`Date`,`Time`,`Method`,`AmountLKR`,`Agent`) SELECT `id` ,`date`,`time`,`method`,`amount`,`location` FROM `cashexpr_cashexpress`.`recievedmoney` INSERT INTO `test`.`dollar_rate` (`DID`,`Date`,`Rate`) SELECT `ID`,`Date`,`Rate` FROM `cashexpr_cashexpress`.`dollar_rate` UPDATE `transactions` SET `Pdf`='Sent' WHERE `Pdf`='sent' UPDATE `transactions` SET `Pdf`='Fail' WHERE `Pdf`='fail'