Transfering data from one database table to another database table

[sree_sri]

Hi sudheer_nm,

I am assuming You have tables like this.

db1---emp_table
db2---emp_table

If it's correct then by using sql copy command you can copy data
from db1 database(emp_table) to db2 database(emp_table).

This is one of the powerfull option to transfer data from one table to another table. Read about this command and let us know if you need help.

Sree.