How to upgrade 7CE ga3 to ga4 when db is hypersonic

[Lucy W, modificado hace 6 años.]

This was asked but not answered in another thread:

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 hace 6 años.]

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

[Lucy W, modificado hace 6 años.]

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?

[Jorge Díaz, modificado hace 6 años.]

Lucy 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 hace 6 años.]

Is 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 hace 6 años.]

Amos 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 hace 6 años.]

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...

[Amos Fong, modificado hace 6 años.]

Jorge,

Thanks for the explanation, that's good to know.

I also saw it in the Digital Enterprise version in a fairly recent fixpack.