In Cognos 10 both the Business insight commentary and human tasks are stored in relational datastores configurable from the cogconfig tool.
The two services (annotation service and human task service) share a database connection but use separate tables with an HTS_ and an ANN_ prefix respectively. The database connection can be configured to be DB2, Derby, Oracle etc
The content of the two databases can be exported to and imported from file using the deploytool that comes with the hts service. The advantage of deployment this way is that it will provide an upgrade path in the next release.
You must ensure that the jdbc driver jar is available in the web-inf lib dir on the install that you are working on.
The deploy tool is exposed via the shell script htsDeployTool.bat and .sh from the install bin directory. It runs a java process that uses JPA to interrogate and serialise the data. All import clashes are avoided and no data will be overwritten.
simply open a shell or cmd prompt in the bin directory with the server running for authentication and type
htsDeployTool -exportFile MyFile1 -camNamespace myNamespace -camUsername nick_mann -camPassword mySecretPassword1
this will by default export your MyInbox tasks to an zipped unencrypted xml file called MyFile1.xml.gz and you should see the stout line
"new deployment file at <install_dir>\bin\..\deployment\MyFile1.xml.gz" followed by some trace about what was deployed.
To add encryption to the file simply add -password myDeploymentPassword
To deploy the annotation service content add -persistenceUnit annotations
To import the tasks to an empty db simply type
htsDeployTool -importFile MyFile1 -camNamespace myNamespace -camUsername nick_mann -camPassword mySecretPassword1
this time you will recieve a lot more trace about what was imported and existing object clash avoidance
1. export business insight commentary to an encrypted file
htsDeployTool -exportFile MyFile1 -password myDeploymentPassword -camNamespace myNamespace -camUsername nick_mann -camPassword mySecretPassword1 -persistenceUnit annotations
2. import unencrypted humanTasks
htsDeployTool -importFile MyFile1 -camNamespace myNamespace -camUsername nick_mann -camPassword mySecretPassword1 -persistenceUnit humanTaskService