Migrating Data from Redshift to Vertica: Best Practices
DieterC
Employee
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
0
Comments
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).