Hi,

I have a CQ system, which is running SQL Server 2005 as its database server. now I want to export the databases and setup another testing environment based on existing CQ system. the future CQ testing system will sit in another machine.

Here are the proposed steps:
1) cqload to export schema
2) create empty schema repository in SQL server 2005, which is running in  testing server.
3) cqload to import schema to testing server.
4) create empty user database in SQL server 2005 in testing server.
5) ???

Please help to continue the steps and share the experience with me. Much appreciated for your kindness.

问题已经解决 [打开主题]

本主题的最佳答案为 [ 7 楼].

Continue to try the following steps:
5) Login CQ Designer with imported schema, create a database associate with you schema, connect to your empty user database.

If the two database server are in the same domain, you can try to use "Move Database" in CQ Maintenance Tool.

if you only use on test environment ,you can reference
http://bbs.scmlife.com/viewthrea ... ght=%2B%C1%F5%C1%F5

Hi,

Thanks for your input.
My problem is that I am not sure when I issue command to import schema, whether the schema repository should exist first or not.

more clearly,
1) shoud I create schema repository (master database) first,
2)export the schema which I try to customerize
3)import the schema to new schema repository

because in IBM's web site, introduce the 2 commands:
cqload exportschema
cqload importschema
however, does  not clearly mention other things, like, the target schema repository exist or not, the detailed steps?

My tasks:
Create another CQ system B from existing CQ system A?
Can any guru give me some detailed steps?

Thanks

Hi,

Actually, I sucessfully export schema. when I was trying to import this schema to another schema repository, error happens,

Starting importschema
*********************************************************

ios::failbit set

*********************************************************
ERROR: importschema FAILED!

any idea?

Thanks

Hi,
Now i get the following erros:(when I execute the command, with no quote on the schema file name)

The schema requires the following package(s), which is(are) not currently instal
led in the database...
    revision '1.0' of package 'AuditTrail'
    revision '1.1' of package 'AuditTrail'.

*********************************************************
ERROR: importschema FAILED!
*********************************************************

any idear??
Thanks

First, you should create a schema repository before import.

something more, before import, compare the original schema and the new import schema.

If the original schema have some packages which the new import schema does not include,

then add the packages one by one until the preparation has done.

Additional info, pls ref: http://www.ibm.com/developerwork ... ?messageID=13807150

最佳答案

该回答被楼主/管理员列为正解!

Hi,
Problem was solved. Just install the packages with the packageutil commands. This is caused by the difference  between target CQ systema and source CQ system.

Thanks