Sunday, February 2, 2014

Using Data mover psdmt utility to refresh table data or move data from one evironment to other

 Hi DBAs,

PSDMT (Data mover) utility is very useful to refresh table data from one environment to other.In the below example DEVDB(Source) and TESTDB(Target).



We can prefer this utility when we have huge amount of tables data to move from one environment to other.
.
Step 1:Go to Peoplesoft Datamover client utility psdmt.
We have to go to People Tools Home and navigate to psdmt.exe


Step 2:Login to Datamover with DEVDB(source) as below:
Login to DEVDB(Source):

user:ADM1
pass:Welcome123

Note:Remove files from temp directory  before performing below steps.
=====


Step 3: Copy the below script in Datamover

Set log c:\temp\log_exp.log;
Set output c:\temp\data.dat;
Export SGA_BVN_MAPPING;
Export SRVC_GROUP_AREA;


Step 4: Import into TESTDB database using datamover(psdmt)

Login to TESTDB(Target):

User:ADM1
pass:welcome123

Step 5:Copy the below script in Datamover

Set log c:\temp\log_imp.log;
Set input c:\temp\data.dat;
import SGA_BVN_MAPPING;
import SRVC_GROUP_AREA;

Step 6:Verify the COUNT OF ROWS in tables on source(DEVDB) and target(TESTDB):
SOURCE:DEVDB

CONN USER1 and give below:

SQL> select name from v$database;

NAME
---------
DEVDB

SQL> select count(*) from USER1.SGA_BVN_MAPPING;

  COUNT(*)
----------
    262742

SQL> select count(*) from USER1.SRVC_GROUP_AREA;

  COUNT(*)
----------
   9864049

TARGET:(TESTDB)

CONN USER1 and give below:

SQL> select name from v$database;

NAME
---------
TESTDB

SQL> select count(*) from USER1.SGA_BVN_MAPPING;

  COUNT(*)
----------
    262742

SQL> select count(*) from USER1.SRVC_GROUP_AREA;

  COUNT(*)
----------
   9864049

Step 7:Send mail
Completed refresh of tables SGA_BVN_MAPPING and SRVC_GROUP_AREA in TESTDB.


Enjoy PeopleSoft DBA tasks.



Best regards,
Rafi


6 comments:

  1. Its really helpful for me to understand where we i lost in my previous interview. Thanks.
    If anyone wants to Learn oracle in Chennai go to the Besant Technologies which is No.1 Training Institute in Chennai.

    http://www.besanttechnologies.com/training-courses/oracle-training

    ReplyDelete