Page 1 of 1

Migrate database to another cluster running different vertica version.

Posted: Sun Mar 20, 2016 7:58 am
by ponimas
Hi!
Is it possible to migrate db to another cluster running higher vertica version?
We have cluster in aws running vertica ce 7.0.1 and want to migrate our db to azure. There is no way to find old vertica ce rpms/debs, so i can not update my current cluster to 7.2.

Re: Migrate database to another cluster running different vertica version.

Posted: Sun Mar 20, 2016 4:41 pm
by NorbertKrupa
You could if you do a manual process; meaning you export schema, users and then import the data. You could also potentially leverage EXPORT TO VERTICA or a utility such as PyVertica. However, if you're going from on-prem to Azure, it could take a while depending on your network speed.

See my blog post for other methods on copying data between clusters.