Thread: Data Transfer
View Single Post
  #4 (permalink)  
Old June 4th, 2003, 11:36 AM
Jeff Mason Jeff Mason is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Then I say for sure DTS is the best way to deal with this, since it allows you to easily set up transformations between source and destination columns.

I'm not aware of any programs which can perform the sort of magic you'd like - somebody is going to have to tell something how to get from Database A to Database B if the mapping is not one-to-one. Thus ultimately it will require both source and destination schemas, and a statement of the rules to employ to map one to the other. DTS does this.



Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote