Can you use ETL successfully as part of the process to migrate from OS/390 to Unix or NT?

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Data Warehousing, ETL, and business intelligence Analyzing an index after rebuild Speed of low-cost query Data warehouse based on operational data model Method other than DB link for large data transfer Data migration with ETL Basic steps for implementing a DBMS Importing 8i dump file to 9i Using export/import process to clone to data warehouse Areas of impact while migrating database from 8i to 9i/10g External tables explained Oracle data and application integration Oracle brings Fusion Middleware into the modern age Risk analysis software now part of Oracle Agile PLM software portfolio SearchOracle.com podcasts Special Report: Collaborate '09 Oracle and Java: Some think advisory board would comfort users Oracle New Year's resolutions, part 1: Advice for navigating 2009 Oracle to acquire application service management firm Oracle updates its enterprise performance management system, details Hyperion integration Podcast: Oracle outlines AIA vision Oracle's 10 steps to get to Fusion rely on Oracle investments

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

The use of an ETL tool to migrate data from one server to another is always a great option. One of the many things that an ETL tool does well is that it allows you to join heterogeneous platforms and databases together to allow you to move information between all these platforms. So using an ETL tool would be very advantageous.

You should also consider if you plan to use the ETL tool for more than data migration. One should look at the overall use of a product and not just a single task. So when you evaluate tools, if you do not already have one in your organization consider all the possible uses for your ETL tool beyond your current task. Since you may find that a tool that is great a data migration, may not be the best tool for your data warehouse strategy. So purchase carefully.

As well you need to look at the required connectivity that you need to ensure that you are able to migrate data across. One thing you did not mention was your source and target databases, however with an ETL we don't need to know this to answer to question, since that is what ETL tools do well is connect many different source types.

Finally I feel that the real advantage of an ETL tool, is that the maintenance, testing, auditing and execution of ETL data migration routines has a lower cost of ownership compared to custom coding. So if you were to ask me, and you did, I would highly recommend looking at en ETL product to migrate your data.