cqload exportintegration

Synopsis

cqload exportintegration: [ -dbset dbset_name ] login password schema name begin_rev end_rev [record_type ] "schema pathname"

Description

The exportintegration subcommand exports revisions of a schema to create a partial schema file for integrating into another schema. This function is useful for advanced users who want to create an integration for use at different sites which are not connected to the network. If you want to export the entire schema, use the exportschema subcommand.

After exporting the partial schema, use the importintegration subcommand to import the data into another schema. The exporting and importing schemas should use similar record types.

Options and arguments

–dbset dbset_name: Connection name. Required if there are multiple schema repositories in the system.
login: ClearQuest® login name of the user. This user must have Super User privileges.
password: ClearQuest password for the user. You must enter an empty set of double quotes ("") if there is no password.
schema name: Name of the schema associated with the integration. The schema name is case sensitive.
begin_rev: First schema revision containing changes that you want to save.
end_rev: Last schema revision containing changes that you want to save.
record_type: Record type for the schema revision data you want to save. Setting this value to " " exports changes for all record types.
schema pathname: Path name of the file that contains the results of exporting the schema revisions. Enclose the path name in double quotes.

Examples

Export changes made to the defect record type only in version 5 of the Enterprise schema.
cqload exportintegration -dbset 2003.06.00 admin "" Enterprise 5 5 defect "c:\tmp\export.txt"
Export changes to the defect record type made in versions 5 through 8 of the Enterprise schema.
cqload exportintegration -dbset 2003.06.00 admin "" Enterprise 5 8 defect "c:\tmp\export.txt"
Export changes made only in version 5 of the Enterprise schema and specify that the ChangeRequest record type will be renamed on import. When you subsequently run the importintegration subcommand, you must specify a new name for the record type.
cqload exportintegration -dbset 2003.06.00 admin "" Enterprise 5 5 ChangeRequest "c:\temp\scriptchanges.txt"

Troubleshooting

If you are having problems exporting a block of schema revisions, try exporting schema versions, one revision at a time. Then, use the importintegration subcommand to import the revisions into another schema.

To export your schema version, create export files for each version by running exportintegration subcommands similar to those shown in the following example:
cqload exportintegration -dbset 2003.06.00 admin "" IBM_SR 8 8 Service_Request "C:\clearquest\schema8.txt" cqload exportintegration -dbset 2003.06.00 admin "" IBM_SR 9 9 Service_Request "C:\clearquest\schema9.txt"