Move Planning databases to another server

[philelmousse]

Hello,

I have my database and Planning webserver on the same server.

I would like to move my database to another server. I know that I can use the export model and data tool for database applications but what are the other steps ?

Thanks

[ericlfg]

Hey Philelmousse,

I typically approach this topic as I would a new install / upgrade.  The databases in BI and EP are, arguably, the most important part aside from the physical software itself.  These steps will allow you to create brand new database objects and allow the product to rebuild dynamic objects inside the database tables.

1. Create a new content store and planning store on the new database instance.
2. Export the content store from cognos connection.
3. Export the planning objects from the CAC (applications, macros, admin links).
4. Bring down services on current system.
5. Reconfigure database objects in cognos configuration to point to the new DB server and databases and start services.
6. Import the content store from cognos connection.
7. Import the planning deployment in the CAC.
8. GTP all applications.
9. Test everything.

*Note: This may be an incomplete list as it's quite possible I missed something as I'm doing this completely from memory.
**Note: If you can perform these steps in a development / test environment first that would be ideal.