Kombinierte Ansicht Flache Ansicht Baumansicht
Threads [ Zurück | Nächste ]
toggle
Arthur Embleton
Migration from Oracle to MySQL
15. April 2013 02:48
Antwort

Arthur Embleton

Rang: New Member

Nachrichten: 1

Eintrittsdatum: 15. April 2013

Neue Beiträge

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
RE: Migration from Oracle to MySQL
15. April 2013 04:27
Antwort

Manish Yadav

Rang: Expert

Nachrichten: 385

Eintrittsdatum: 26. Mai 2012

Neue Beiträge

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
RE: Migration from Oracle to MySQL
15. April 2013 04:42
Antwort

Juan Gonzalez

LIFERAY STAFF

Rang: Liferay Legend

Nachrichten: 2141

Eintrittsdatum: 28. Oktober 2008

Neue Beiträge

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.