This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Duplicating data from remote database to local databse" Watch "Duplicating data from remote database to local databse" New topic

Duplicating data from remote database to local databse

Gurunath Kale

Joined: Jul 08, 2007
Posts: 14
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
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32481

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

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3740

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.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Duplicating data from remote database to local databse
It's not a secret anymore!