Foren
Migration from Oracle to MySQL
Arthur Embleton, geändert vor 11 Jahren.
Migration from Oracle to MySQL
New Member Beitrag: 1 Beitrittsdatum: 15.04.13 Neueste 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?
Can I just export the data and structure over to MySQL? Has anyone done this before?
Manish Yadav, geändert vor 11 Jahren.
RE: Migration from Oracle to MySQL
Expert Beiträge: 493 Beitrittsdatum: 26.05.12 Neueste 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 .
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.
RE: Migration from Oracle to MySQL
Liferay Legend Beiträge: 3089 Beitrittsdatum: 28.10.08 Neueste 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.
Control Panel -> Server Administration -> Database migration.