Data migration is the process of importing legacy data to a new system. It is a routine part of IT operations in today’s business environment.

Common Data Migration Scenarios :
* Mergers and acquisitions
* Legacy system modernization
* Enterprise application consolidation, implementation, or upgrade, such as an SAP ERP or CRM implementation
* Master data management implementation
* Business process outsourcing

Here I show you how ETL tool can help to speed up the data migration process using Advantage Data Transformer as my tool. You can’t find much information about this product in fact,I don’t know who on earth is using this product beside me. Although it is not popular compared to DataStage or Informatica but it help me a lot. It just enought.

Most of the thing is drag and drop.easy right.

Define your transformation if any. (You know you are geek if you can read this. )

 

Change your store processing,generate and ETL script (this will be major different compared other ETL tools.Script will be in VB like ) and finally run your script.

Here are the console to monitor your job.

Of course in real situation it will not be as simple as this.This is just for education purpose.

Till then..adios.

p/s: Thanks to Allah…zaima is recovering.Pray that she can survive from Meningitis.