IBM Support

How to create new Controller 10.1 database, or create copy of an existing database, or move existing database to new SQL server

Troubleshooting


Problem

Customer would like advice on how to create/copy/move a Controller SQL database.

Symptom

.

Environment

The advice in this Technote is based on:
  • Controller 10.1 (released June 2011)
  • SQL 2008 R2
 

TIP: For advice on how to move Controller 10.3.1 databases, see separate IBM Technote #0795804.

Resolving The Problem

See attached document "1594174 - Basic Database Tasks, using SQL 2008 and Controller 10.1.pdf".

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
18 January 2019

UID

swg21594174