Can Vertica database be migrated to any cloud database like Postgresql?

Can Vertica database be migrated to any cloud database like Postgresql? Are there any utilities available to do the migration? I am talking about close to 1 TB of data?

Answers

  • SruthiASruthiA Vertica Employee Administrator

    please check with postgresql if they have any utilities. we will be able to help if you want to move the data from other databases to vertica.

  • VValdarVValdar Vertica Employee Employee

    Hi vasanthvk,
    Just so you know, Vertica works in most cloud providers too.
    Licenses are also portable: if you have 2 TB license, you can set 1 TB on-prem and 1 TB in the cloud).

  • marcothesanemarcothesane - Select Field - Administrator

    If you already have a Vertica Database on prem; and if you want the same node count - and the same Vertica version - in the Cloud, all you do is backup the on-prem database; In the case of Azure, GCP or AWS, provision a n-node Vertica Cluster on MarketPlace and restore it in the Cloud - and then, if needed, manage the delta accrued at the source after the taken backup - and off you go

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file