#1 May 1, 2018 8:24pm

zbfxfg
Member
Registered: May 1, 2018
Posts: 2

Oracle Database Migration from mySql

Hi sir, This sounds stupid but. is there a way that I can set Bigtree DB in the Oracle Database instead of mySql? Because our server is using Oracle DB as a standard. And is there a way that I can migrate from localhost db to Oracle without messing up my data and set up of Bigtree?

Offline

#2 May 2, 2018 9:20am

timbuckingham
Administrator
From: Baltimore, MD
Registered: April 2, 2012
Posts: 970

Re: Oracle Database Migration from mySql

I've never worked with an Oracle database so I'm not sure what would be involved in configuring BigTree to work on Oracle.

Offline

#3 May 5, 2018 6:49am

zbfxfg
Member
Registered: May 1, 2018
Posts: 2

Re: Oracle Database Migration from mySql

Thank you so much for that Info sir.

Offline

#4 June 28, 2018 10:54am

Gaumer
Member
Registered: June 21, 2018
Posts: 1

Re: Oracle Database Migration from mySql

zbfxfg wrote:

Thank you so much for this fantastic D-Bal review and that Info sir.

Hi Tim, it's supposed to work though, isn't it? I have limited knowledge about Oracle, but I don't see why it wouldn't. Unless I'm missing something important.

Last edited by Gaumer (October 21, 2022 9:11am)

Offline

#5 June 28, 2018 10:57am

timbuckingham
Administrator
From: Baltimore, MD
Registered: April 2, 2012
Posts: 970

Re: Oracle Database Migration from mySql

I have never actually attempted to use BigTree on top of an Oracle back-end. I'm not familiar enough with the Oracle vs MySQL syntax differences to know how well it would translate. In theory, if the SQL syntax is compatible you should be able to place a replacement SQL interface class in /custom/inc/sql.php which replaces the sql function calls with calls to Oracle rather than mysqli.

Offline

#6 July 1, 2019 5:36am

gloriamartin
Member
From: Australia
Registered: July 1, 2019
Posts: 2
Website

Re: Oracle Database Migration from mySql

Its great information thank you for the information.

Offline

Board footer

Powered by FluxBB

The Discussion Forum is not available on displays of this size.