Thread: Data Transfer
View Single Post
  #8 (permalink)  
Old June 6th, 2003, 07:38 AM
psingh psingh is offline
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Guys,
Does anyone know whats the best way to define rules which can be used to map data from one database to another one? Could it be an XML file mapping which shows what columns map to what? But then it would probably get too big because the input database is huge. Also one column could be split into many or many into one based on final destined schema (which is not in place yet). DTS will be used at the back end to move data but i am a little unclear about the mapping architecture. Any ideas, suggestions. Thanks!

Paul
Reply With Quote