nz_migrate works well and is very efficient - I've used this very successfully to do such a migration.

D.

nz_migrate exports data in internal compressed format from the source system and pipes this directly to nzload processes on the target system - it automatically does this in parallel streams for large tables, and you can selectively migrate tables or schemas.

D.

The best thing to do is to run nz_migrate -? which will give documentation on the current available switches

D.

In my case, I am using nzbackup (differential) to 'refresh' data from production to development. I am not sure if nz_migrate can perform 'differential'.

Well, nz_migrate can't do it out of the box, but it's just a script. Lot's of people customize it to do what they need. All of the nz uilities are scripts that you can tailor.

Can the nz support tool kit be installed on a AIX client? We dont have access to the host..It seems like the contrib tool kit is not part of the AIX CLI package

It was designed to run on the host but many parts of it will work fine on another system as long as you have installed the standard Netezza client software that includes nzsql and the other commands.  The nz_migrate script in particular will not work from a remote host..