migrating data with identity columns

Moderator: NorbertKrupa

Post Reply
sreediff
Newbie
Newbie
Posts: 18
Joined: Mon Mar 28, 2016 2:51 pm

migrating data with identity columns

Post by sreediff » Wed Mar 30, 2016 11:07 am

How to migrate tables having identity columns and keep the number same across both servers?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: migrating data with identity columns

Post by JimKnicely » Wed Mar 30, 2016 11:42 pm

Hi,

Check out the documentation for "Copying Data" and see if it helps It explains how to copy tables that have identity columns.

https://my.vertica.com/docs/7.2.x/HTML/ ... ngData.htm
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

sreediff
Newbie
Newbie
Posts: 18
Joined: Mon Mar 28, 2016 2:51 pm

Re: migrating data with identity columns

Post by sreediff » Thu Mar 31, 2016 6:16 am

JimKnicely wrote:Hi,

Check out the documentation for "Copying Data" and see if it helps It explains how to copy tables that have identity columns.

https://my.vertica.com/docs/7.2.x/HTML/ ... ngData.htm
Thanks Jim,
I don't have connectivity set up between servers

dbadmin=> CONNECT TO VERTICA <> USER dbadmin PASSWORD '<>' ON 'ip_address',5433;
CONNECT
dbadmin=> COPY test_1 FROM VERTICA test_1 DIRECT;

dbadmin=> COPY test_1 FROM VERTICA test_1 DIRECT;
ROLLBACK 4236: One or more nodes did not open a data connection to this node. This may indicate a network configuration problem. Check that the private interfaces used for communication among the cluster hosts reside in the same subnet and are returned first by host address lookup
ERROR 4789: [dbname] Statement is canceled

To avoid this issue i plan to manually create dump in csv file and import the data from csv in another server.

Post Reply

Return to “Vertica Migration”