Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How to alter table to have uuid?
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
If your table is:
Then, if you use CSV files for the migration, export all columns to CSV, create the same table on the other side and perform a normal
COPY migrate_me FROM '/data/migrate_me.csv' DELIMITER ',' /* or whatever applies */[...];
.If you had no UUID at the source (I did not figure that out exactly from your question), like so:
, then also export all columns you have, create the table like so on the other side:
, and copy the CSV file like so:
thanks for the response sir @marcothesane