Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Appendix D Migrating PeopleSoft Data for Adapter Configuration : Migrating PeopleSoft Data for Adapter Configuration

Migrating PeopleSoft Data for Adapter Configuration
Database migration scripts are provided to allow you to migrate PeopleSoft data for your adapter configuration, from one database to another. This utility allows you to maintain your configuration data in one repository and extract to other databases as required. For instance, you can migrate data from a development environment to a production environment instead of repeating the process of preparing PeopleSoft Component Interfaces and other adapter specific components in the production environment. The scripts provided migrate the following data:
The migration process broadly involves the following steps. An export script and an import script are provided along with the installation. Run the export script on the source database to extract data for a specified Operation Class Id and Component Interface(s). The output is generated in a .dat file, which is placed in a specified location. Login to the target database, and run the import script. The migration process is complete.
Script File Location
The following database migration scripts and a sample export script are available in the TIB_ADPSFT8_HOME\scripts directory:
tibexport.dms (Export Script)
tibimport.dms (Import Script)
tibexport_sample.dms (Sample Export Script)
Adapter Configuration Migration
The migration procedure can be divided into the following three parts:
Exporting Adapter Configuration Data
Use the following steps to carry out the export procedure:
1.
Go to the TIB_ADPSFT8_HOME\scripts directory and open the tibexport.dms script using a text editor like notepad.
2.
You can see the sample export script tibexport_sample.dms located in the scripts directory.
The values specified in the tibexport.dms script must be enclosed in single quotes. If data for multiple Component Interfaces is to be extracted use comma separators. Do not include spaces after the comma.
3.
Set the name and location of the output .dat file generated by the tibexport.dms file in either of the following ways:
Modify the SET OUTPUT parameter in the tibexport.dms file
The default output file name is tibmigration.dat.
The default location is PS_HOME\data directory.
a.
b.
In the Profile tab, select the client configuration being used (usually named "default") then click the Edit button.
c.
In the Edit Profile window select the Common tab. In the Data Mover Directories block specify the path for the output directory and the log file.
If the SET OUTPUT parameter has been modified in the tibexport.dms file. This setting will override the location specified in Configuration Manager. You can use Configuration Manager only to specify locations and not file names.
4.
Modify the SET LOG parameter in the tibexport.dms file.
The default name is tibmigration_export.log.
The default location is TIB_ADPSFT8_HOME\scripts.
5.
Save the modified tibexport.dms script file with a new name. For example, tibexport_new.dms.
6.
7.
Run the modified export script file, for example, tibexport_new.dms in PeopleSoft Data Mover.
8.
A .dat file, tibmigration.dat containing the adapter configuration data is generated in the location specified in step 3.
Importing Adapter Configuration Data
Use the following steps to carry out the import procedure:
1.
Set the name and location of the .dat file to be imported by the tibimport.dms file in either of the following ways:
Modify the SET INPUT parameter in the tibimport.dms file.
The default output file name is tibmigration.dat.
The default location is PS_HOME\data directory.
a.
b.
In the Profile tab, select the client configuration being used (usually named "default") then click the Edit button.
c.
In the Edit Profile screen select the Common tab. In the Data Mover Directories block specify the path for the input directory and the log file.
2.
Modify the SET LOG parameter in the tibimport.dms file.
The default name is tibmigration_import.log.
The default location is TIB_ADPSFT8_HOME\scripts.
3.
If the SET INPUT parameter has been modified in the tibimport.dms file. This setting will override the location specified in Configuration Manager. You can use Configuration Manager only to specify locations and not file names.
4.
Modify the SET LOG parameter.
The default name is
tibmigration_import.log.
The default location is TIBCO_HOME\adapter\adpsft8\version_number\scripts.
5.
Go to the TIB_ADPSFT8_HOME\scripts directory and run the tibimport.dms script. The migration procedure is complete.
Verification
To verify that the migration has been successful do the following:
Ensure that a .dat file, tibmigration.dat has been generated in the specified directory.
Check the log files for errors. The default log files, tibmigration_export.log and tibmigration_import.log are located in the TIB_ADPSFT8_HOME\scripts directory by default, unless you have specified otherwise.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved