Migrate PeopleSoft Enterprise Portal Managed Content Data with DMS
By Chris Malek | Tue, Jul 31, 2012
Here is a DMS script that will export Enterprise Portal Managed Content data where you can import into another database.
The user interface for this is: Content Management > Managed Content > Browse Folders
I have tested this migrating data between Release 9 to Release 9.1. There did not seem to be any structure changes between those releases for these tables. I am sure someone will find this useful.
set log C:\TEMP\content_export.log; set OUTPUT C:\TEMP\e9_cm_export.dat; EXPORT EPPCM_CONTENT; EXPORT EPPCM_CATG_MEM; EXPORT EPPCM_CATG_CONT; EXPORT EPPCM_DOC; EXPORT EPPCM_HTMLTEXT; EXPORT EPPCM_DOCINDB; EXPORT EPICP_WF_CNTAPR; EXPORT EPICP_TMPL_HDR; EXPORT EPICP_TMPL_DETL; EXPORT EPICP_INST_HDR; EXPORT EPICP_INST_DETL; EXPORT EPPCM_CATEGORY;
PeopleSoft Simple Web Services (SWS)
Do you need a quick way to create web services?
Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.
Integration Broker - The Missing Manual
I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.