Suljettu

PHP Database table export and import (Oracle 11g to MySQL)

I need a well written php script that will connect to an oracle DB which lives on “serverA”, run a select statement on a table and then import the results into a mysql database table “serverB”. The script must drop the current data that is contained in the MySQL table before inserting the new data.

Once the import/export package is completed, I would like to use cron or windows scheduler to run this job on a daily basis.

ServerA (Solaris & Oracle 11G)

ServerB (Windows running wamp, MySQL version [url removed, login to view], [url removed, login to view], [url removed, login to view])

The final scripts should be well documented so if I need to modify them later, like connect strings or add additional tables I can do this on my own. Also I would like error’s and success visible, so if the script fails I know what is happening.

As you will not have access to my servers, this job will be complete and successful when I can do the following:

1. Update the PHP scripts with my own Database server information (both MySQL and Oracle).

2. Update the PHP script with my own queries and inserts.

3. Run script, which will make a valid connection to both DB’s

4. Drop current data in a table on the MySQL db.

5. Query a table on the OracleDB

6. And insert the queried data into the MySQL db.

7. Provide a status on the php page that the process is working, completed or in error.

Taidot: Tietokannan hallinto, MySQL, Oracle, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: mysql import oracle 11g database, export oracle database mysql, php export oracle database, import oracle mysql query php, import oracle 11g database mysql, what is oracle package, wamp with php 5.6, wamp server php, select package oracle, export job, db import export, database scripts with php and mysql, query table, php oracle mysql, php database, oracle queries, oracle job, import/export, import export, export mysql, export import, php data table, import access database php, update status script php, update status php mysql

About the Employer:
( 2 reviews ) Lawrenceville, United States

Projektin tunnus: #4264322

13 freelanceria on tarjonnut keskimäärin 88 $ tähän työhön

gopalvora

ready to start Thanks

75 $ USD 4 päivässä
(130 arvostelua)
6.7
diegou

Hello please check pmb

145 $ USD 2 päivässä
(34 arvostelua)
5.6
pablotorres

i can do it

75 $ USD 31 päivässä
(60 arvostelua)
5.3
webprof2

Please Check PMB.

150 $ USD 5 päivässä
(34 arvostelua)
5.0
ptakacs

Dear Sir, please let me help you. Regards: Peter.-

100 $ USD 3 päivässä
(1 arvostelu)
4.5
hatem87

Hi, I am software engineer. I have a great experience in this database stuff. Please check PM. Thanks.

60 $ USD 2 päivässä
(7 arvostelua)
4.5
jomel80

I can make you this job.

50 $ USD 5 päivässä
(1 arvostelu)
0.7
deb4t1

I would like to bid for this project. Please view PM for details.

150 $ USD 3 päivässä
(0 arvostelua)
0.0
CentrixSystem

it is an easy job to do, this is the area of my forte. let me know if I can help you.

100 $ USD 1 päivässä
(0 arvostelua)
0.0
sonica4

Hi,I would like to bid on this project on behalf of Veebrij Group. Veebrij IT Services offer complete Oracle product cloud, consulting, support & development solutions across the world. Our Managed Services deliver co Lisää

124 $ USD 7 päivässä
(0 arvostelua)
0.0
aftabahd

let me help you ..its easy :D

60 $ USD 8 päivässä
(0 arvostelua)
0.0
pallaavis

PLEASE CHECK PPM

70 $ USD 2 päivässä
(0 arvostelua)
0.0
patkerl

ready to start your job

70 $ USD 3 päivässä
(0 arvostelua)
0.0
OracleDBAGuru

i Can do this thanks

70 $ USD 5 päivässä
(0 arvostelua)
0.0