#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: 844

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

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.

Offline

#5 June 28, 2018 10:57am

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

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 March 11, 2019 6:39am

mical10
Member
Registered: March 11, 2019
Posts: 1

Re: Oracle Database Migration from mySql

zbfxfg wrote:

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?

MySQL and Oracle Database are complementary databases best suited to different use cases. In cases where you need to migrate, SQL Developer is a free and fully supported product that provides tools and utilities to migrate from MySQL to Oracle.

Offline

Board footer

Powered by FluxBB

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