This week's book giveaway is in the Features new in Java 9 forum.
We're giving away four copies of Java 9 Revealed and have Kishori Sharan on-line!
See this thread for details.
Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Duplicating data from remote database to local databse  RSS feed

 
Gurunath Kale
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Currently I am accessing remote data base for my project. I am connecting it through VPN (cisco). Although its serving my purpose but I am facing some other performance issues.
So I am planing to transfer the data I required from the remote data base to my local database.
Can anybody help me in 'How to transfer data from remote data base to local data base'.
My remote database server is Microsoft SqlServer2000 and Local is Mysql server5.0
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 36622
474
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Gurunath,
The easiest way is to export the data to a comma or tab delimited file and import it on your local database.
 
Scott Selikoff
author
Bartender
Posts: 4083
21
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you mean a one-time transfer or a perpetually (nightly/hourly) transfer? The first being easy with the use of database exports/imports built into the database software, while the latter being a much more complicated issue.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!