Using Data Mover Scripts to Copy Message Schema and WSDL Data

In PeopleTools 8.50 message schema and WSDL documents became managed objects.

To move message schema and WSDL documents from PeopleTools 8.50 and later databases to PeopleTools 8.48 databases or PeopleTools 8.49 databases, use the data mover scripts described in the following table. These scripts are located in the <PS_HOME>\scripts directory.

Object

Script Name

Description

Message schema.

PSIBMSGSCHEMA_EXP.DMS

Export a message schema from a PeopleTools 8.55 database.

Message schema.

PSIBMSGSCHEMA_IMP.DMS

Import a message schema into a PeopleTools 8.55 database.

WSDL document.

PSIBWSDL_EXP.DMS

Export a WSDL document from a PeopleTools 8.55 database.

WSDL document.

PSIBWSDL_IMP.DMS

Import a WSDL document into a PeopleTools 8.55 database.

The WSDL data mover scripts move WSDL by WSDL name, not service name. Therefore it is possible to select specific WSDL for importing/exporting for a given service.

You may encounter errors while moving large WSDL documents and schemas from a Microsoft SQL, Oracle or Informix platform to a Sybase or DB2 (UNIX or OS/390) platform because of size restrictions in Sybase and DB2. The maximum size of WSDL documents from Microsoft SQL, Oracle or Informix platforms to DB2 or Sybase platforms is described in the following table:

Note: Beginning in PeopleTools 8.55 Informix and Sybase are no longer supported.

Source Platforms

(PeopleTools 8.50 and later)

Target Platform

(PeopleTools 8.48 or PeopleTools 8.49)

Maximum WSDL/Schema Size (Bytes)

  • Microsoft SQL

  • Oracle

  • Informix

    (Not supported beginning in PeopleTools 8.55.)

DB2 – UNIX

32700

DB2 – OS/390

31744

Sybase

(Not supported beginning in PeopleTools 8.55.)

32000