File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes copy data between two different servers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "copy data between two different servers" Watch "copy data between two different servers" New topic

copy data between two different servers

phani ravinutala

Joined: Jun 25, 2009
Posts: 26

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.


Philip Thamaravelil
Ranch Hand

Joined: Feb 09, 2006
Posts: 99
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.

I agree. Here's the link:
subject: copy data between two different servers
It's not a secret anymore!