Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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 Employee

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.