Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Arthur Embleton
Migration from Oracle to MySQL
April 15, 2013 2:48 AM
Answer

Arthur Embleton

Rank: New Member

Posts: 1

Join Date: April 15, 2013

Recent Posts

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
April 15, 2013 4:27 AM
Answer

Manish Yadav

Rank: Expert

Posts: 385

Join Date: May 26, 2012

Recent Posts

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
April 15, 2013 4:42 AM
Answer

Juan Gonzalez

LIFERAY STAFF

Rank: Liferay Legend

Posts: 2136

Join Date: October 28, 2008

Recent Posts

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.