The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

REMOTE COPY

Is it a good idea to use COPY LOCAL from DC that is remote to current DC? This will make COPY easy, otherwise I'll first have to copy all the data from remote DC, then load data to Vertica

Comments

  • "DC" == "data center"? I haven't personally tried this myself. But in principle it should be an entirely reasonable thing to do. COPY LOCAL is just establishing a TCP connection and shipping the file data over it. Which is presumably what you'd be doing anyway, using one protocol or another. One potential caveat, COPY LOCAL does not encrypt transmitted data. So there might be security concerns with a direct-over-the-Internet connection. Though, if you're connecting two data centers, hopefully you have a secure VPN solution that you can use.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.