Migration of all Databases with all users and grant & privileges of IBM Netezza from one to Another server

 #############################################################################

Migration of all Databases with all users and grant & privileges of IBM Netezza from one  to Another server

##############################################################################

Please Use Below steps to migrate from one server to another server.

1. Take DDL of All Users.

nz_ddl_user > nz_ddl_user.sql

2. Take DDL of All Groups one by one Important 

nz_ddl_group GroupName >  nz_ddl_group_GroupName .sql

3. Take DDL of Grant given to groups one by one Important 

nz_ddl_grant_group DBname > nz_ddl_grant_group_DBname .sql

4. Take DDL of Grants to given to all user.

nz_ddl_grant_user > nz_ddl_grant_user.sql

5. Move all SQL file to other server and import it.

From OS run it.

nzsql < nz_ddl_user.sql 

connect to each database and run

nzsql -d dbname -f  nz_ddl_group_GroupName .sql

connect to each database and run

nzsql -d dbname -f nz_ddl_grant_group_DBname .sql

nzsql <  nz_ddl_grant_user.sql

6. Now Migrate All Databases using nz_migrate, below are the few examples.

nz_migrate -shost Source-Host -thost Target-Host -sdb NZDB -tdb NZDB -suser admin -spassword Source_passwd  -tuser admin -tpassword targetpasswd -format binary  -genStats Express  -CreateTargetTable YES -CreateTargetDatabase yes -threads 10 -Status

Note :- If you want to rename database during nz_migrate

nz_migrate -shost Source-Host -thost Target-Host -sdb POMSDB-tdb N_POMSDB -suseradmin -spassword Source_passwd  -tuser admin -tpassword targetpasswd -format binary  -genStats Express  -CreateTargetTable YES -CreateTargetDatabase yes -threads 10 -Status