Generate DDL of Users, Groups, Tables, Views & Functions and Procedure in IBM Netezza

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

  Generate DDL of Users, Groups, Tables, Views & Functions and Procedure in IBM Netezza

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


Here is the OS  command to Generate DDL of Users, Groups, Tables, Views & Functions and Procedure in IBM Netezza.


DDL for all user run this from OS.

nz_ddl_user > nz_ddl_user.sql  ## output will be in file nz_ddl_user.sql

DDL for single user  MJAISWAL run  below command to generate.

nz_ddl_user MJAISWAL > nz_ddl_user_MJAISWAL.sql 

## output will be in file nz_ddl_user_MJAISWAL.sql

DDL all groups 

nz_ddl_group > nz_ddl_group .sql

DDL for all grant given to groups.

nz_ddl_grant_group > nz_ddl_grant_group.sql

To Migrate all MetaData of IBM Netezza from to another server, Please use below steps.


Move all Genrated SQL  file to other server and import it in new server.


nzsql < nz_ddl_user.sql 

nzsql <  nz_ddl_group .sql

nzsql < nz_ddl_grant_group.sql



There are below command to generate DDL for all other purpose .

nz_ddl_user 
nz_ddl_group 
nz_ddl_grant_group 
nz_ddl_grant_user   
nz_ddl_mview  
nz_ddl_schema   
nz_ddl_view
nz_ddl_ext_table   
nz_ddl_group    
nz_ddl_table       
nz_ddl_function  
nz_ddl_owner 
nz_ddl_database  
nz_ddl_grant_group 
nz_ddl_procedure  
nz_ddl_synonym