Transfer Data from one database to other.

20 pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    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.
    5,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following