Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am going to be working on a migration of Oracle DW to Netezza, and I need to understand if there are any major "gotchas" with data types, etc.

share|improve this question
Out of interest, what's driving the migration? Features or Cost? – Nick Pierpoint Feb 21 '10 at 20:54

This Wisdomforce tool is pricey, has too many restrictions, and requires DBA access to the source database.

We just completed a project extracting huge amount of data (in TB) from Oracle to Netezza every night. We are using DBCrane, which is much easier to use.

share|improve this answer
up vote 0 down vote accepted

Should not be major gotchas unless you have object types or Spatial objects in Oracle Check few docs below, you might find it useful:

share|improve this answer
thank you very much. – Bob Feb 21 '10 at 13:10

Here is one more pdf on similar subject in case need an incremental migrations based on transactions:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.