Different ways to Transfer data from one database to another database
Hi all,
What are the ways to transfer data from one database to another database. With the following options, i Can transfer data as far as i know. Please
correct me if i am wrong or tell me if there is any other options are available.
1) Create database link/connection string and using this string and COPY command, we can transfer data.
2) By using Export and Import utilities.
I told first one to my interviewer, he told, its strange, by using, COPY command also can we transfer data ? As far as i know, we can transfer data. Am i right ?
Thanks in advance,
Pal