identity columns -migrate data

Hi,

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

Thanks

will it work if i migrate between two servers? backup is using vbr.py? is there no utility like export/expdp in oracle?

Hi ,

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

I hope you will find it useful

Thanks