identity columns -migrate data

sreeblr

How to migrate data between tables having identity columns

eli_revach

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

sreeblr

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

eli_revach

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