copy data between two different servers

[phani ravinutala]

Hi,

I have one table emp on the server1.Another table with same name emp on second server2.

What is the easy query to copy data from the table emp on the first server1 to table emp on the server2?
I am trying in JDBC. I am using MQSQL.

Thanks,

[Philip Thamaravelil]

Phani,
Not a lot of information given in the OP, but traditionally this type of task is done with an ETL. If your using MSSQL you can use Microsoft Data Transformation Services (DTS) or there are open-source tools available that can connect over JDBC to other databases.

Might be more work initially, but will payoff the next time to need to transform data.

Cheers,
Philip