How do I extract a full database table?

Document ID : KB000012574
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How do I extract a full database table? 

Answer:
  1. Take a backup of the table to be loaded before running any command
  2. In the prod environment : run pdm_extract yourtablename > yourtablename.txt 
  3. In the Test environment : run the pdm_load -f yourtablename.txt with applicable flags 
  4. After load the table in your Test environment run pdm_cache_refresh -t yourtablename 

 

Additional Information:

PDM_EXTRACT FLAGS

Usage: C:\PROGRA~2\CA\SERVIC~1\bin\rgen or pdm_extract 

[ -h (help) ] 

[ -f (format string) ] 

[ -c (CSV output) ] 

[ -e (CSV output with double double quotes) ] 

[ -r (informal report output) ] 

[ -v (verbose) ] 

[ -s (saved_script) ] 

[ -u (no headers) ] 

[ -d (use dataent.fmt) ] 

[ -x (locale sensitive numeric formats) ] 

[ -X (extract all tables except table list) ] 

[ -B (do not include UTF-8 Byte Order Mark (BOM) (set by NX_ADD_UTF8_BYTE_ORDER 

_MARK )) ] 

[ -C (convert output to named charset or 'DEFAULT' to use default charset) ] 

ALL | database table names .... 

 

***************

PDM_LOAD FLAGS 

usage: pdm_load -f [filename | -] 

[-a (update all matching data)] 

[-c (check only, no change to data)] 

[-e (treat escapes literally)] 

[-h (help)] 

[-i (insert only)] 

[-m (notify domsrvr of mass update)] 

[-v (verbose)] 

[-r (remove) | -u (update only)] 

[-x (use locale sensitive numeric input formats)]