Move Schema Repository or User DB

Move Schema Repository or User DB

We can use the ClearQuest tool to move the schema/user db to another physical db (same vendor or different vendor). Here are the details

Using ClearQuest Maintenance Tool to move the schema db and CQ designer for user db. Before start, new empty db should be created accordingly. Click menu Move under Schema Repository in CQ Maintenance Tool to move schema db. Click Move User Database under Database in CQ Designer to move user database. It is easy to do and understand with the action wizard except following attentions,

1.  The moved db(s) should be empty. If the db has the replica of the user db or schema db, you can use Update function in CQ designer and CQ Maintenance Tool.

2.  Notify all users logoff the user db
3.  Backup all schema db and user dbs for uncertain things happened.
4.  Export the updated connection file to other site and import the file if multisite.
5.  Moving schema db and user db do not change the oplog.