Possibility of exporting data from oracle database to SQL database through php

Asked By 20 points N/A Posted on -
qa-featured

Hello,

I want to know about the possibility to export data from Oracle to SQL database through PHP.

Is it really possible?

If possible then, what is the procedure?

I hope to get some help on this.

Thanks 

SHARE
Answered By 0 points N/A #196590

Possibility of exporting data from oracle database to SQL database through php

qa-featured

Hi,

 Database Gateway for ODBC (Dg4ODBC) in SQL statements through PHP coding can be optimally exercised to have replaced data from Oracle to MYSQL. 

Let us cite a stare to support Oracle Database:

With concern to choose from PHP by means of DG4ODBC do not have accurate results And Error – Ora-1002 (Doc ID 753321.1),

which furnish an illustration. The code may be furnished in the $SQL segment and the case is –

$sql = "select id from dbo.msql_table@dblink"; //the sql statement is in the quotation marks cause the variable of it is string.

It is very amenable to copy data from Oracle to MySQL without any prior selection in this regard.

Within this application we can check any statements work from SQLPLUS prior to adopting PHP code.

In case of availability of code for linking to both databases in PHP, it is mandatory to:

1. Choose data from Oracle into  given arrangements or variables based on timestamp that somebody can choose.

2.  Data coding from step #1 into MySQL using the mysql link.

Obviously it is straightforward without any complication . This is quite easy to just select and insert into mysql and entrust. Other way it can be utilized in database jobs in oracle to put data in Mysql database routine using ODBC gateway based links. This is will not affect any worse to work than using select comment and then documenting in MySQL.

REGARDS

Related Questions