Vertica Eon Mode from Enterprise Mode

hdk0310

Hi ,
I have Vertica version 9.2 Enterpriose mode and I would like to shift to Eon Mode.
Is there any way I can migrate Enterprise mode to Eon mode. As per vertica documents you cannot directly switch between Enterprise Mode and Eon Mode. You choose the mode for your database when you create it. Once created, you cannot change the database's mode. If you want to use a different mode, you must back up your data, create a new database using the new mode, and then reload your data.

Is there any other way to migrate data from Vertica Enterprise mode to Eon mode.

SruthiA

Apart from what is mentioned in the documentation. There is no way to migrate data from Enterprise to EON mode.

hdk0310

Let me re-frame the questions: How can I migrate from Enterprise Mode to Eon Mode?
I read the documentation it has not been given in detail.
For Example:
Will copy cluster work there? Or Backup Restore? Or Export ?

SruthiA

One way is to export data to S3 from your existing database using s3export function and run COPY from S3 in your EON mode database.

Jim_Knicely

You can can import/export data across databases (i.e. Enterprise to Eon)

See:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/CopyExportData/CopyingAndExportingData.htm

hdk0310

Thanks SruthiA And Jim.
Any idea on Backup and restore? Since the catalog is large with lot of tables.
Data volume is also huge. Can I do Enterprise backup and restore in EON?

Jim_Knicely

@hdk0310 - Currently you cannot use the vbr utility to take a full backup of a Vertica Enterprise DB and then restore it to Vertica EON DB.

hdk0310

Thanks Jim