Transfer Data from one database to other.
Home > IT Answers > DataManagement > Transfer Data from one database to other.
4knowledgexchng
20 pts.
0
Q:
Transfer Data from one database to other.
Database Management Systems, Database migration
Hi all,
How to transfer datas from one database which has completelly different structure to other datebase with different structure?
How to map these database?
Is there any tool which does this?
If so please suggest some free tool.



Please help.


Thank you all in advance.
ASKED: Oct 15 2009  5:56 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
CharlieBrowne
6540 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Unless you file file descriptions for both systems and the field names care exactly the same, a tool is not going to be found that can do this.
You need to define all your fields in the source system and the files they are comming from.
Then do the same with the target system.
Most likely you will have some fields that do not map and you to make a determineation for each one.
Last Answered: Oct 15 2009  12:21 AM GMT by CharlieBrowne   6540 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Meandyou   1840 pts.  |   Oct 15 2009  1:36PM GMT

CharlieBrowne’s answer is absolutely correct. to sum up his approach, one must know the data and the application systems that use it. This is called analysis; a skill that is sometimes overlooked nowadays.

 
0