How to copy data via csv file between clusters
I have some tables in Cluster 1 - I want the data from these tables copying to another cluster for a refresh and sone testing - Its not possible to do this using export so I am trying to use copy .. On the source cluster I am dumping the data to a file as follows (Which seems to give me a CSV / txt file) vsql -U user_name -w user_password -F ',' -At -o exp_USER_PASSWORD_HISTORY.txt -c "select * from USER_PASSWORD_HISTORY;" I copy the text fiile to the other cluster. The user on the other cluster is the same / the table already exists (same structure) and has been truncated. Now I am struggling to get the copy into the destination cluster to work, Please advise?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.