Migrating content store and DW from SQL Server to Oracle
Does anybody know the process to follow when migrating the content store and DW databases from SQL Server to Oracle. I know there are ORACLE tools to convert a SQL database to Oracle, so was wondering if doing this and then reconfiguring the Congos Configuration Manager to point to the new Content Store would work
2 answers
1. export all the content from report server's administration, it will create a zip file under <insight_install_dir>/cognos/deployment folder
2. create a new content store database with required tablespace and buffer pool, refer to cognos install and configuration guide.
3. copy the oracle jdbc driver jar files to <insight_install_dir>/cognos/webapps/p2pd/WEB-INF/lib
4. open cognos configuration, change the content database pointing to the new one
5. re-start the web application on WAS, it will create tables in the new content store database.
6. after report server is started, import the content from the zip file in deployment folder.
2. create a new content store database with required tablespace and buffer pool, refer to cognos install and configuration guide.
3. copy the oracle jdbc driver jar files to <insight_install_dir>/cognos/webapps/p2pd/WEB-INF/lib
4. open cognos configuration, change the content database pointing to the new one
5. re-start the web application on WAS, it will create tables in the new content store database.
6. after report server is started, import the content from the zip file in deployment folder.