详解二：
CQSchema不同服务器间的导出导入
一、导出schema
运行命令：
X:\Program Files\Rational\ClearQuest>cqload exportschema -dbset
exported_schema liuliu 123 TestStudio "E:\scm\bugs.txt"
用法及解释：
cqload exportschema –dbset
//命令及参数
dbset_name //sample_schema,
ini连接文件的名称
clearquest_login //liuliu
CQ用户
clearquest_password //123
用户密码
schema_name //TestStudio
导出的库所基于的schema的名称
script_full_path_name //"E:\scm\bugs.txt"
成功后会看到以下字样，并且在E:\scm目录下生成一个bugs.txt的文本文件，这个文件不用手动创建，完成后将这个文件考到需要导入的机器中的某个路径下。
*********************************************************
Starting
exportschema
*********************************************************
*********************************************************
Successfully
completed
exportschema
*********************************************************
二、导入schema
1、首先在要导入schema的数据库上建立相对应的几个数据库
2、在maintencetool里new个新的schema
3、个人觉得在导入前先设置好codepage（在此前，先将admin默认的空密码改掉）。
设置codepage命令如下：
运行cmd 输入命令：
installutil setdbcodepagetoplatformcodepage -dbset
imported_schema admin 123
用法及解释：
installutil setdbcodepagetoplatformcodepage –dbset
//命令及参数
imported_schema
//在mentencetool里建的schema的名称
admin
//admin用户
123
//admin的密码 改掉后的
成功后会看到如下字样：
*********************************************************
Starting
test
setdbcodepagetoplatformcodepage
*********************************************************
Validating that database MASTR supports code page 936 (ANSI/OEM -
Simplified C
hinese GBK)...
Successfully validated all databases.
Note:
this command does not guarantee that all of the text in
this dbset is
compatible with this code page setting. Please
refer to the ClearQuest
Release Notes for more information.
Successfully set the code page to: 936
(ANSI/OEM - Simplified Chinese GBK).
*********************************************************
Exit code 0
for test
setdbcodepagetoplatformcodepage
*********************************************************
4、下面就可以导入schema了，运行命令：
X:\Program Files\Rational\ClearQuest>cqload
importschema -dbset imported_schema admin 123 " E:\scm\bugs.txt
"
用法及解释：
cqload importschema –dbset
//命令及参数
dbset_name // imported_schema
这是在maintencetool里建的new的ini
clearquest_login //admin
clearquest_password //123 用户密码
schema_script_full_path
//" E:\scm\bugs.txt "，假如将导入机子也有此目录
5、如果报错如下，则需要安装相应的包：
*********************************************************
Starting
importschema
*********************************************************
The import file "E:\SCM\export_schema\change.txt" is invalid:
The schema
requires the following package(s), which is(are) not currently installed in the
database...
revision '2.0' of package 'Customer'
revision '3.0' of
package 'Notes'
revision '3.0' of package 'DefectTrackingSetup'.
*********************************************************
ERROR:
importschema
FAILED!
*********************************************************
6、解法如下，依次输入命令：
C:\Program Files\Rational\ClearQuest>packageutil
installpackage -dbset 成都开发部故障管理系统 admin "123456789" Customer 2.0
C:\Program
Files\Rational\ClearQuest>packageutil installpackage -dbset 成都开发部故障管理系统 admin
"123456789" Notes 3.0
C:\Program Files\Rational\ClearQuest>packageutil
installpackage -dbset 成都开发部故障管理系统 admin "123456789" DefectTrackingSetup
3.0
7、安装后再重新输入导入命令，成功后会看到一下字样：
*********************************************************
Starting
importschema
*********************************************************
*********************************************************
Successfully
completed
importschema
*********************************************************
这样，就成功的导入了schema了。
还有种命令是import/export
两种版本之间差异的.以下是我近期整理的,大家交流一下吧.例子比较简单
---------------------------------------------------------------------
Copying a Schema into a Schema Repository
1 Export the schema (all
revisions) you want to copy using the command exportschema.
2 Import the
copied schema into the schema repository using the command importschema.
Copying a Partial Schema into an Existing Schema
1 Export part of a
schema (one or more revisions) using the command exportintegration.
2 Import
the copied schema into an existing schema using the command importintegration.
Import CQ DB schema:
Importschema
Use the importschema subcommand, part of the cqload command
line utility, to import an entire schema from a text file and add it to your
schema repository. This subcommand is useful for sharing schemas with sites that
can not access your schema repository or that use a different schema repository.
Before using importschema, you must export the schema using the exportschema
command. To import a partial schema, use the importintegration subcommand.
Syntax
cqload importschema [–dbset name] login password
“schema_pathname”
Example:
cqload importschema –dbset 2003.06.00 admin “”
“c:\schema.txt”
The preceding example imports a schema (exported in text form
and saved in c:\schema.txt) into the current schema repository.
Importintegration
Use cqload importintegration subcommand to import
schema modifications exported with cqload exportintegration.
Note: If
ClearQuest MultiSite is in use, importintegration can only be performed at the
working master site.
Syntax
cqload importintegration [–dbset name] login password
schema_name[ new_record_type_name ] ”integration name” integration_version
“schema_pathname” ”form_name”
Example
cqload importintegration -dbset 2003.06.00 admin “***" CR2006 ""
"comment" 54 "d:\work\CR2005from45to53.txt" “”
The preceding example imports
the exported schema into the CR2006 schema, leaving all record types with their
original names.
export CQ DB schema
Exportschema
Use the exportschema subcommand, part of the cqload command
line utility, to export an entire schema to a text file. You can then use the
importschema subcommand to import the schema into another schema
repository.
To export a partial schema, use the exportintegration
subcommand.
Syntax
cqload exportschema [–dbset name] login password schema_name
“schema pathname”
Example
cqload exportschema –dbset 2003.06.00 admin “” DefectTracking
“c:\schema.txt”
The preceding example exports the contents of the
DefectTracking schema to the file c:\schema.txt
Exportintegration
Use cqload exportintegration to export specific
versions of a schema in a form that can be used to modify an existing schema. To
import the data into another schema, use the importintegration subcommand. The
exporting and importing schemas should use similar record types.
Syntax
cqload exportintegration [–dbset name] login password schema_name
begin_rev end_rev [ record_type_to_rename ] “schema_pathname
Example
cqload exportintegration –dbset 2003.06.00 admin '’ Enterprise 5
8 ““ “c:\tmp\export.txt”
The preceding example exports changes made in
versions five through eight of the Enterprise schema
