Đã Đóng

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 5.5.24, PHP5.5.13, Apache2.2.22)

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.

Kĩ năng: Quản trị cơ sở dữ liệu, MySQL, Oracle, PHP, Kiến trúc phần mềm

Xem nhiều hơn: php scheduler, php mysql export import scripts, access export, cron import cron, query mysql database information, php mysql insert success, update database php, php5 database, insert php database, mysql cron job, scheduler php, cron script database, php mysql update query, access script import data, mysql run script, php add query, php query data access database, mysql howto import database ssql, php import export, update php page

Về Bên Thuê:
( 2 nhận xét ) Lawrenceville, United States

ID dự án: #4264322

13 freelancer đang chào giá trung bình $88 cho công việc này

gopalvora

ready to start Thanks

$75 USD trong 4 ngày
(498 Nhận xét)
8.3
diegou

Hello please check pmb

$145 USD trong 2 ngày
(41 Nhận xét)
6.0
pablotorres

i can do it

$75 USD trong 31 ngày
(152 Nhận xét)
6.2
ptakacs

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

$100 USD trong 3 ngày
(1 Nhận xét)
4.2
hatem87

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

$60 USD trong 2 ngày
(7 Nhận xét)
4.5
deb4t1

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

$150 USD trong 3 ngày
(6 Nhận xét)
3.7
patkerl

ready to start your job

$70 USD trong 3 ngày
(3 Nhận xét)
3.5
jomel80

I can make you this job.

$50 USD trong 5 ngày
(1 Nhận xét)
0.4
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 trong 1 ngày
(0 Nhận xét)
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 Thêm

$124 USD trong 7 ngày
(0 Nhận xét)
0.0
aftabahd

let me help you ..its easy :D

$60 USD trong 8 ngày
(0 Nhận xét)
0.0
pallaavis

PLEASE CHECK PPM

$70 USD trong 2 ngày
(0 Nhận xét)
0.0
OracleDBAGuru

i Can do this thanks

$70 USD trong 5 ngày
(0 Nhận xét)
0.0