Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC 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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "copy data between two different servers" Watch "copy data between two different servers" New topic
Author

copy data between two different servers

phani ravinutala
Greenhorn

Joined: Jun 25, 2009
Posts: 26
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
Ranch Hand

Joined: Feb 09, 2006
Posts: 99
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: copy data between two different servers