Skip to main content

Migrating Data from Redshift to Vertica: Best Practices

  • May 28, 2018
  • 1 reply
  • 5 views
DieterC
Forum|alt.badge.img+2

Hi forum,

a Vertica (and Redshift) client is looking for best practices to migrate database tables from Redshift to Vertica.
What can we recommend please?
What experience do have available?

Thank you
Dieter

    1 reply

    Darych
    • Darych
    • New Participant
    • May 28, 2018

    Hi,

    I haven't tried this. But to me, it looks like the best approach will be to unload data to S3 using unload() function (https://docs.aws.amazon.com/redshift/latest/dg/c_unloading_data.html) and then using COPY command load data to Vertica (https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkLoadCOPY/AWSLibrary/importAWSlibrary.htm).

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement