Exporting and Importing PS Security

It is actually pretty easy to export and import the security from PeopleSoft. There are datamover scripts that are given to. They are located in the PS_HOME PeopleSoft installation directory.

PS datamover scripts

Export and import the security from PeopleSoft

You do have to realize that this export script simply exports all of the security. You can’t really pick and choose. But it is great for backups and even for server refreshes.

Exporting – Step 1

To export security, simply login to DataMover.

Login to DataMover

Exporting – Step 2

Go to File > Open.

DataMover - File Open

Exporting – Step 3

Select your securityexport.dms script.


Exporting – Step 4

You have to set the export location for both the .DAT file and the log file.

PS export

Exporting – Step 5

Then you simply hit the Run Script button or F5.



To import, the steps are exactly the same, except you open the securityimport.dms file and point it to the path of your export file.

You may also like:

PeopleSoft Favorites – Authorization Error Discovered some users today that couldn't add favorites in PIA. Whenever they would try to add one they would get the following error: Authorization E...
Disable TypeAhead Feature for Everyone In certain versions of PeopleTools, the TypeAhead feature simply doesn't work very well. It causes weird behavior, such as the mouse cursor disappeari...
Error: “Application Attempted to perform an ... Are you getting a .NET Framework error? "Application attempted to perform an operation not allowed by the security policy. To grant this application t...
PS – Move/Copy a Query to a new Database Here are instructions for moving/copying queries back and forth between different PeopleSoft databases. PeopleSoft Database Queries This includes mo...
Creating a SQL view/record for PSQuery Have you every been annoyed by creating a query in PIA, using PSQuery? The easier way to do it is to create a new record, turn that into a view, and t...
READ ALSO  Relationship CI not found (14000,317)
  • irene be

    Hello, just a further question of Security Data Mover. Will this script show me what security each role has? And which employee is associated to which role?