cqload exportintegration

Export schema revisions to create a partial schema file for integrating into another schema.

Applicability

Platform: Windows™

Command type: cqload subcommand

Synopsis

: cqload exportintegration [-dbset dbset] loginID password schema beginRev endRev [recordType] schemaPathName

Description

The cqload exportintegration subcommand exports schema revisions 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 that are not connected to the network. Then, use the cqload importintegration subcommand to import the data into another schema. The exporting and importing schemas should use similar record types.

To export the entire schema, use the cqload exportschema subcommand.

Options and arguments

–dbset dbset: Connection name. Required if there are multiple schema repositories in the system.
loginID: Login name of the user. This user must have Super User privileges.
password: Password for the loginID user. If there is no password, you must enter an empty set of double quotes ().
schema: Name of the schema associated with the integration. The schema name is case sensitive.
beginRev: First schema revision containing changes that you want to save.
endRev: Last schema revision containing changes that you want to save.
recordType: Record type for the schema revision data that you want to save. Setting this value to an empty set of double quotes () exports changes for all record types.
schemaPathName: 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 2013.01.00 admin secret Enterprise 5 5 Defect "c:\tmp\export.txt"
Export changes to the Defect record type that were made in versions 5 through 8 of the Enterprise schema.
cqload exportintegration -dbset 2013.01.00 admin secret Enterprise 5 8 Defect "c:\tmp\export.txt"
Export changes made only in version 5 of the Enterprise schema, specifying that you want to rename the ChangeRequest record type on import. When you subsequently run the cqload importintegration subcommand, you must specify the new name for the record type.
cqload exportintegration -dbset 2013.01.00 admin secret Enterprise 5 5 ChangeRequest "c:\temp\scriptchanges.txt"

Troubleshooting

If you are having problems exporting a block of schema revisions, try exporting schema revisions individually. Then, use the cqload importintegration subcommand to import the revisions into another schema.

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