There are variety of tools available to use in the data migration process by both advanced and beginner developers. These tools are contingent upon the compatibility of the data environment and platform dependent.
Informatica Power Center – A functional programming tool for platform accessing, reporting and integrating data.
Ascential Data Stage – Provides OnDemnd data integration.
ESS Base Hyperion – Creates analytic and enterprise performance management applications.
Business Objects: Data Integrator – Builds data marts, ODS systems and data warehouses.
SAS Data Integration – Generates data streams, data marts and data warehouses.
Microsoft Data Transformation Services (DTS) – Aids data movement issues, and automates ETL processes through databases.
Oracle Warehouse Builder – Provides fully integrated relational and dimensional modeling and the management of data and metadata, among other functions.
For more tips on data migration read eCommerce Best Practices book