Migrate database to another cluster running different vertica version.

Moderator: NorbertKrupa

Post Reply
ponimas
Newbie
Newbie
Posts: 1
Joined: Sun Mar 20, 2016 7:46 am

Migrate database to another cluster running different vertica version.

Post by ponimas » Sun Mar 20, 2016 7:58 am

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.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

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

Post by NorbertKrupa » Sun Mar 20, 2016 4:41 pm

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.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “New to Vertica Database Administration”