vbr.py

Moderator: NorbertKrupa

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

vbr.py

Post by sreediff » Mon Aug 08, 2016 5:47 pm

can vbr.py be used to copy tables between two servers.?

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: vbr.py

Post by NorbertKrupa » Fri Aug 12, 2016 4:11 pm

Not sure what enhancements have been made, but vbr.py was intended for a database level backup/restore. For a table level copy, I would use EXPORT TO VERTICA or COPY FROM VERTICA (note that the table structure does not get copied)
Checkout vertica.tips for more Vertica resources.

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

Re: vbr.py

Post by JimKnicely » Sat Aug 13, 2016 2:08 am

Check out the "Replicating Tables and Schemas to an Alternate Database" doc:
https://my.vertica.com/docs/7.2.x/HTML/ ... luster.htm

Or, check out the "Copying and Exporting Data" doc:
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.

Post Reply

Return to “Vertica Community Edition”