| 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: 3652
|
|
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
|
 |
 |
|
|
subject: Data Transfer
|
|
|