aspose file tools
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


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Data Transfer" Watch "Data Transfer" New topic
Author

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
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3738
    
  10

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]
 
wood burning stoves
 
subject: Data Transfer