Ditutup

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.

Kemahiran: Pentadbiran Pangkalan Data, MySQL, Oracle, PHP, Kejuruteraan Perisian

Lihat lagi: 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

Tentang Majikan:
( 2 ulasan ) Lawrenceville, United States

ID Projek: #4264322

13 pekerja bebas membida secara purata $88 untuk pekerjaan ini

gopalvora

ready to start Thanks

$75 USD dalam 4 hari
(130 Ulasan)
6.7
diegou

Hello please check pmb

$145 USD dalam 2 hari
(34 Ulasan)
5.6
pablotorres

i can do it

$75 USD dalam 31 hari
(60 Ulasan)
5.3
webprof2

Please Check PMB.

$150 USD dalam 5 hari
(34 Ulasan)
5.0
ptakacs

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

$100 USD dalam 3 hari
(1 Ulasan)
4.5
hatem87

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

$60 USD dalam 2 hari
(7 Ulasan)
4.5
jomel80

I can make you this job.

$50 USD dalam 5 hari
(1 Ulasan)
0.7
deb4t1

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

$150 USD dalam 3 hari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
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 Lagi

$124 USD dalam 7 hari
(0 Ulasan)
0.0
aftabahd

let me help you ..its easy :D

$60 USD dalam 8 hari
(0 Ulasan)
0.0
pallaavis

PLEASE CHECK PPM

$70 USD dalam 2 hari
(0 Ulasan)
0.0
patkerl

ready to start your job

$70 USD dalam 3 hari
(0 Ulasan)
0.0
OracleDBAGuru

i Can do this thanks

$70 USD dalam 5 hari
(0 Ulasan)
0.0