This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Duplicating data from remote database to local databse Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Duplicating data from remote database to local databse" Watch "Duplicating data from remote database to local databse" New topic
Author

Duplicating data from remote database to local databse

Gurunath Kale
Greenhorn

Joined: Jul 08, 2007
Posts: 14
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


░▒▒▓ ĞŨЯŨ ▓▒▒░
Back To Make Things Better
SCJP
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30050
    
149

Gurunath,
The easiest way is to export the data to a comma or tab delimited file and import it on your local database.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3700
    
    5

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.


My Blog: Down Home Country Coding with Scott Selikoff
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Duplicating data from remote database to local databse
 
Similar Threads
RMI : rmi and t3 protocol HELP.....
help needed
ip addresses
XML Parser
Help with SOAP