Thursday, April 2, 2009

Data Mover Script

Export
set output c:\temp\temp.dat;
set log c:\temp\temp.log;
export table_name where key_field = '123'; /* without PS_ */

Import
set input c:\temp\temp.dat;
set log c:\temp\tmp.log;

delete from ps_table_name where key_field = '123';
import *;

OR

import table_name;

No comments: