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