File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Data Transfer 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 "Data Transfer" Watch "Data Transfer" New topic

Data Transfer

fahad siddiqui
Ranch Hand

Joined: Jun 14, 2006
Posts: 85
I want to generate scripts to transfer data from one table to another in MS SQL 2000.

But, the dbs are not same and i have certains constraints for transferring data and the structures of tables are different, hence, i need flexibility to specify transfer for each column accordingly.

Is there some tool available for the purpose?
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

Depends, do you want to repeat this transfer as part of a java application over and over again or is this a one-time transfer?

If its the latter, you can always export to a CSV or SQL statement file and use a text editor to move around and replace pieces. If you need this as part of a java application, you'll likely need to code your own conversion tool.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Data Transfer
It's not a secret anymore!