Hi there,
I'm looking to migrate the two Cognos 8 Planning databases from SQL 2000 to SQL 2005 (in sql 2000 Compatibale mode)
I have been able to migrate the Cognos application databases, although not been able to source the pad_live and pad_live_common databases connections.
Does anyone know how to migrate the two system pad databases from one SQL server to another, ie change the database server name within the app.
Thanks