Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

copy data between two different servers

 
phani ravinutala
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic