Here are instructions for moving/copying queries back and forth between different PeopleSoft databases.
PeopleSoft Database Queries
This includes moving between different versions of PeopleTools.
Launch App Designer on the server you are wanting to move/copy your queries from.
Go to “File > New > Project” and hit “Ok.”
Move to the “Upgrade” tab on the bottom left section in App Designer.
Click “Insert > Definitions into Project…”
Select the “Definition Type” as Queries. Select your query or queries and hit “Insert.” In this example I am simply copying the ACAD_PLAN_TBL (delivered query) over to a new server. Most likely you are copying over a custom built query that you named yourself.
Now before you can export your query you have to save it to a project. So go to “File > Save Project As…” and select a temporary name for your project. You can always delete it when you are finished transferring.
Now it’s time to export your project. Go to “Tools > Copy Project > To File.” You will want to save to a file if you are transferring your queries to a PS database that is a different version of PeopleTools. If you are transferring your queries between the same version of PeopleTools, then simply select “To Database”, login, and your done! Otherwise, continue reading.
Connect to your destination database and then go to “Tools > Copy Project > From File…” And your done!