Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Data Transfer

 
fahad siddiqui
Ranch Hand
Posts: 85
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 4033
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!