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