Fórum
How to upgrade 7CE ga3 to ga4 when db is hypersonic
Lucy W, modificado 6 Anos atrás.
How to upgrade 7CE ga3 to ga4 when db is hypersonic
Junior Member Postagens: 50 Data de Entrada: 21/09/16 Postagens Recentes
This was asked but not answered in another thread:
And I have the same question. If we have a dev server that uses hypersonic database, is there a way to use the upgrade tool to update ga3 to ga4?
If not, what is the upgrade process?
Spa Movy:
How about upgrade of local development server GA3 to GA4, which uses hypersonic?
Update tool supports only "db2 mariadb mysql oracle postgresql sqlserver sybase", no hypersonic..
And I have the same question. If we have a dev server that uses hypersonic database, is there a way to use the upgrade tool to update ga3 to ga4?
If not, what is the upgrade process?
Jorge Díaz, modificado 6 Anos atrás.
RE: How to upgrade 7CE ga3 to ga4 when db is hypersonic (Resposta)
Liferay Master Postagens: 753 Data de Entrada: 09/01/14 Postagens Recentes
Upgrade process is not supported nor tested for hypersonic database.
You should only use hypersonic database for small demos.
To avoid problems, you should move from hsql to postgresql, mysql or mariasql
You should only use hypersonic database for small demos.
To avoid problems, you should move from hsql to postgresql, mysql or mariasql
Lucy W, modificado 6 Anos atrás.
RE: How to upgrade 7CE ga3 to ga4 when db is hypersonic
Junior Member Postagens: 50 Data de Entrada: 21/09/16 Postagens Recentes
Ok thanks. Would be helpful to include this quality (not-upgradableness) in the docs or install prompts, so devs know the trade-off in choosing hypersonic db for a dev instance.
Is there a way to export data from hypersonic and import to mysql?
Is there a way to export data from hypersonic and import to mysql?
Jorge Díaz, modificado 6 Anos atrás.
RE: How to upgrade 7CE ga3 to ga4 when db is hypersonic
Liferay Master Postagens: 753 Data de Entrada: 09/01/14 Postagens RecentesLucy W:
Ok thanks. Would be helpful to include this quality (not-upgradableness) in the docs or install prompts, so devs know the trade-off in choosing hypersonic db for a dev instance.There is a warning message during Liferay startup that says you should only use it for demo purposes
Lucy W:
Is there a way to export data from hypersonic and import to mysql
Liferay 7 doesn't provide any tool to convert from one database to other. The only existing option from Liferay is to export/import data using LAR files, but it only works at site level.
Search in internet some external tool to convert your database for example, in a quick search I found: https://stackoverflow.com/questions/28454620/migration-hsqldb-to-mysql-using-mysql-workbench-6-2 and https://ralf.schaeftlein.com/2012/02/18/migrating-hsqldb-to-mysql/
Amos Fong, modificado 6 Anos atrás.
RE: How to upgrade 7CE ga3 to ga4 when db is hypersonic
Liferay Legend Postagens: 2047 Data de Entrada: 07/10/08 Postagens RecentesIs there a way to export data from hypersonic and import to mysql?
There is a data migration tool in the control panel that should be able to do this. I could not find the 7.0 docs (I checked, it's still there though) but here is the 6.2 one:
https://dev.liferay.com/discover/portal/-/knowledge_base/6-2/server-administration#data-migration
Jorge Díaz, modificado 6 Anos atrás.
RE: How to upgrade 7CE ga3 to ga4 when db is hypersonic
Liferay Master Postagens: 753 Data de Entrada: 09/01/14 Postagens RecentesAmos Fong:
There is a data migration tool in the control panel that should be able to do this. I could not find the 7.0 docs
Hi Amos,
That data migration tool was removed in Liferay 7.0
Long explanation: that tool was not adapted to osgi architecture and only migrates some tables, so it was removed (see: https://issues.liferay.com/browse/LPS-65828 ) but there was some mistake and 7.0 community version GA1, GA2 and GA3 includes the buggy tool.
Lucy W, modificado 6 Anos atrás.
RE: How to upgrade 7CE ga3 to ga4 when db is hypersonic
Junior Member Postagens: 50 Data de Entrada: 21/09/16 Postagens Recentes
Well that explains why it didn't work.
Thanks all.
Note: Just installed 7.0 ga4 and the data migration tool seems to still be included...
Thanks all.
Note: Just installed 7.0 ga4 and the data migration tool seems to still be included...
Amos Fong, modificado 6 Anos atrás.
RE: How to upgrade 7CE ga3 to ga4 when db is hypersonic
Liferay Legend Postagens: 2047 Data de Entrada: 07/10/08 Postagens Recentes
Jorge,
Thanks for the explanation, that's good to know.
I also saw it in the Digital Enterprise version in a fairly recent fixpack.
Thanks for the explanation, that's good to know.
I also saw it in the Digital Enterprise version in a fairly recent fixpack.