![]() |
Copyright © Cloud Software Group, Inc. All Rights Reserved |
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.
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)
1. Go to the TIB_ADPSFT8_HOME\scripts directory and open the tibexport.dms script using a text editor like notepad.
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. Open Configuration Manager, then click the Profile tab.
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.
− 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.
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.
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. Open Configuration Manager, then select the Profile tab.
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.
− 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.
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.
− 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.
−
− 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 |