migrating data with identity columns
Moderator: NorbertKrupa
migrating data with identity columns
How to migrate tables having identity columns and keep the number same across both servers?
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: migrating data with identity columns
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
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: migrating data with identity columns
Thanks Jim,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
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.