wood burning stoves 2.0*
The moose likes JDBC 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
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

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.


My Blog: Down Home Country Coding with Scott Selikoff
 
Consider Paul's rocket mass heater.
 
subject: Data Transfer
 
Similar Threads
Are these patterns the same
ssh example in java.
Passing value to EJB from Servelet
copying all of the objects in one schema over to another schema
Value Object, Data Transfer Object and Domain Object