打印

[TechNote] How to export and import ClearQuest schemas（此文章被查看:1946次,被回复:5篇!! ）

懂你

管理员

Rank: 9

超级水手

楼主大中小发表于 2006-10-8 17:57 只看该作者

How to export and import ClearQuest schemas

Problem

This technote explains how to export and import IBM® Rational® ClearQuest® database schemas.

Solution

ClearQuest (CQ) has a command line utility,cqload, that allows an entire schema to be exported from one schema repository (MASTR) database and imported into another.

To use cqload, it is necessary to use the DOS command prompt. In addition, the schema to be exported, must not be checked out. If cqload is run while the CQ Designer is open, it will need to be closed, then restarted in order to show the changes made by cqload.

The exportschema subcommand is used to export an entire schema to a text file. This schema text file can then be imported into another schema repository using the importschema command. The syntax and examples of both commands are shown below.

cqload exportschema -dbset <connection name> <cq-login> <cq-password> <schema name> "<script full path name>"

Parameter	Description
<connection name>	Existing connection associated with the schema repository database as viewed in the CQ Maintenance Tool. 2003.06.00 (shown in above example) is the default set up automatically in the 2003 release of the CQ Maintenance Tool.
<cq-login>	CQ administrative login name
<cq-password>	CQ administrative password (enter "" if the value is blank)
<schema name>	Name of the schema exactly as it appears in CQ Designer. This is case sensitive.
<script full path name>	This must be surrounded by double quotes. A UNC path format can also be used.

Example:

cqload exportschema -dbset 2003.06.00 admin "" DefectTracking "c:\temp\schema.txt"

This command will export the contents of the DefectTracking schema to the file c:\temp\schema.txt.

The importschema subcommand is used to import an entire schema from a textual representation, and add it to the schema repository. It can be useful for sharing entire schemas with sites that cannot access the main schema repository, or have a different schema repository.
cqload importschema -dbset <connection name> <cq-login> <cq-password> "<script full path name>"

Example:

cqload importschema -dbset 2003.06.00 admin "" "c:\temp\schema.txt"

Note: The file C:\temp\schema.txt was created using the cqload exportschema command. During that process, the name of the exported schema was saved into this file. So when this schema is imported, the schema name will be used to create the schema with cqload importschema. If that name is already in use in destination schema repository, the import will fail.