How to migrate data between tables having identity columns
Vertica do not suport simple way to do that!
The why i know that should work for sure is:
1) take object backup
2) rename source table to target
3)restore from backup.
I hope you will find it useful
will it work if i migrate between two servers? backup is using vbr.py? is there no utility like export/expdp in oracle?
Looks like its doable from 7.2 see NodeMapping -> https://my.vertica.com/docs/7.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/ConfigFileReference/[NodeMapping].htm