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.
feedback
|
|
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 | |||
feedback
|
|
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 | |||
|
feedback
|
|
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. | |||
|
feedback
|
