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;
Article Categories
Author Info
Chris Malek

Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.

About Chris Work with Chris
Looking for pain-free PeopleSoft web services? 😀
PeopleSoft Simple Web Services (SWS)

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.

Book
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.