Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

3 Answers 3

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.

http://www.bronzeage.us/downloads.html

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:

http://www.wisdomforce.com/resources/docs/OracleToNetezzaWithFastReader.pdf

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: http://www.wisdomforce.com/resources/docs/databasesync/DatabaseSyncBestPracticesforNetezza.pdf

share|improve this answer

Your Answer

 
discard

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