Migration from Oracle to MySQL

[Arthur Embleton, geändert vor 11 Jahren.]

I am currently using Liferay 6.0.6 connected to Oracle v11.2.0.2.0. I am investigating what would be required for a migration to MySQL v5.5.

Can I just export the data and structure over to MySQL? Has anyone done this before?

[Manish Yadav, geändert vor 11 Jahren.]

You can divide migration in Two steps

1. Migration of Table structure
2. Migration of Data


1. Tables will automatically creates when you start liferay[No need to export of table structure]
2. You can use SQL Developer for export insert statements .

[Juan Gonzalez, geändert vor 11 Jahren.]

Not sure if this feature I'll tell you exist in 6.0.6 (it does in 6.1).

Control Panel -> Server Administration -> Database migration.