As followup to you post if i use EXPORT to VERTICA its able to copy sequence from source to target server.
However if i dont have direction connection and have to create a dump of data using vsql its a challenge to insert into tables ignoring identity column since the sequence get reset. if EXPORT To VERTICA is able to do this is there any setting which enables copy/insert to vertica tables and then start the sequence from the last sequence.
hi mike. can you provide steps /ini file used to copy table data between two vertica server. What all files need to be copied to target .
Can we do incremental for a table ?