Migrate MySQL to Oracle

[navtek007]

Hi All,

I have the requirement to migrate my MySQL database to Oracle 9.2.x. Has anyone done this yet? I was basically going to run the Oracle Migration workbench to create the export then import into an oracle schema on another server. From here I would then recompile the zabbix server to point to oracle.

Can the oracle database live on a seperate server then the zabbix server?

Is that all I have to do to move the data accross? I can setup the db username and passwords to reflect the db.inc etc.. Am I missing something or is there a better migration strategy out there? Alexei what do you recommend?

Thanks in advanced.

[blouz]

Hello navtek007,

Did you perform this upgrade ?
I would need to perform the same task.
Additionnally, I would like to upgrade from 1.0 using mysql to 1.1 using oracle.

The steps would be 1.0->1.1 then 1.1 mysql -> 1.1 oracle.
Does anyone already perform this kind of migration ?

regards, blouz.

[Alexei]

Can the oracle database live on a seperate server then the zabbix server?

Is that all I have to do to move the data accross? I can setup the db username and passwords to reflect the db.inc etc.. Am I missing something or is there a better migration strategy out there? Alexei what do you recommend?

I know many ZABBIX installations having Oracle running on a dedicated server. I think you should follow standard (i.e. there is nothing ZABBIX specific) way of moving data from MySQL to Oracle.

[thiagomz]

I am trying to do it ...

I have been used SQL Developer (Oracle Free) to migrate... but some data was lost... now i will try to use a utf8 oracle database ...

Any one did it ? I mean... migrate from mysql to oracle...

PS. I am doing it... because i am a OCP DBA and i haven't a lot o knowledge in mysql. ;-)

[Zaniwoop]

Oracle bought mysql.

So I suggest you learn it