SEO

#1 (**permalink**) 02-26-2008, 05:57 PM

Anyone know of any ETL or DataMapping software that
can be used to migrate to IBM DB2 from Oracle?

Thanks,
DWB

#2 (**permalink**) 02-26-2008, 05:57 PM

dwb@selectpersonnel.com (DWB) wrote in message news:<153021a6.0405061102.5ace7e93@posting.google. com>...
> Anyone know of any ETL or DataMapping software that
> can be used to migrate to IBM DB2 from Oracle?

depends:
- how much do you want to spend?
- what is the complexity of the conversion?
- is this a one-time migration or an automated feed?
- near real-time or batch?
- etc

Assuming that it's a one-time, and you don't want to spend much:
- it ususally isn't that hard to write by hand. The entire thing can often be
nicely handled with spooled output from oracle, an occasional perl/python/tcl
conversion script and import/loads for db2. This can actually be much easier
than using some ETL tools.
- SQL Server's DTS is cheap ($5k) if not fast
- Data Junction is the next step up (something like $1500-$5000)
- SyncSort has a simple ETL product that is also reasonably priced

Beyond the above options, the costs & complexity pretty much skyrockets.

ken

#3 (**permalink**) 02-26-2008, 05:57 PM

DWB wrote:

> Anyone know of any ETL or DataMapping software that
> can be used to migrate to IBM DB2 from Oracle?
>

I _believe_ the IBM Migration Toolkit (free) includes tools to help
extract data from Oracle and load it into DB2. You can download
it from:

http://www-306.ibm.com/software/data/db2/migration/mtk/

Good luck.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

ETL & Data Mapping