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.
Dig Deeper on Oracle business intelligence and analytics
Related Q&A from Ian Abramson
A SearchOracle.com member asks why a low-cost query has a slower speed than expected. Continue Reading
We are working on the development of a datamart (in 9i) which takes data from two source systems. Since this is a transaction system, there is a lot ... Continue Reading
I am new to Oracle's ETL tool and I need information on data migration using Oracle ETL. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.