Tuesday, October 14, 2014

steps by steps table refresh between Netezza server

pre -request
target tables should have same strcuture as source tables structure.

then issue the below command to migrate the tables.

nz_migrate -shost SRCHOST_NAME -thost TRGETHOST_NAME -format binary -sdb SRCDB_NAME -tdb TRGET_NAME -suser admin -t FT_INSTOCK -threads 4 -cksum Yes -genStats Express -TruncateTargetTable Yes

No comments:

Post a Comment