Understanding the PeopleSoft Data Migration Workbench
The PeopleSoft Data Migration Workbench facilitates the Configuration Management process to migrate application configuration data. Using Application Data Sets (ADS) as its underlying transport technology, the Data Migration Workbench enables you to compare, validate, and copy the content data from one database to another.
The Data Migration Workbench is an effective alternative to Data Mover scripts, providing greater visibility and control of managed changes in your environments. Any authorized developer or administrator can easily define application data sets using the PeopleSoft Pure Internet Architecture (PIA) and compare and copy the data in much the same way as the copy and compare process of managed objects.
Note: You can still use Data Mover scripts to load application data; however, Data Mover does not provide a way to compare and validate the data that is copied. Although ADS does provide basic validation, you should validate your results by running tests using test environments first before using ADS to migrate data to your production environment.
For more information regarding application data sets and the Data Migration Workbench, see
Data Migration Using Application Data Sets
The Application Data Set functionality is comprised of the following components:
Data Set Designer
Data Migration Workbench
Data Set Designer
Authorized administrators use the Data Set Designer to create data set definitions (ADS definitions) as a hierarchical structure of records and their collective properties.
A data set definition, with its group of records, constitutes a data set. Both record definitions and data set definitions are metadata that define the shape of the migration data. The same data set definition must exist in any PeopleSoft database that participates in a data set copy or compare.
Data Migration Workbench
Authorized administrators can then use the Data Migration Workbench to insert data set instances (data content) into projects that represent a unit of work as a data migration project. Data migration projects are like managed object projects: a collection of data set instances with various data set definitions. The Data Migration Workbench enables administrators to copy and compare projects containing data sets as well as view compare reports and validation reports.
You can also integrate the Enterprise Components Approval Framework to provide administrative control of the Project Copy from File process. Employ enhanced security to ensure that the Data Set definitions are suitable for copying data, to enable user security for the PIA data set pages, and assign access to copy and compare the data. PeopleSoft delivers the MigrateData process ID for enabling data migration Approval Framework. For more information, see