Question Re: Changing CMS Database in Technology Q&A

Changing CMS Database

Former Member — Tue, 28 Jan 2014 14:31:24 GMT

Hi,

We have installed SAP BI 4 with the default DB on the same server as we didnt have the independnt DB available.

I want to now copy the data from the default DB to a new one which we will be using.

I have had a look at the guide and the steps I am looking to do are

1. Use the CCM to stop the Server Intelligence Agent (SIA).

2. Select the SIA and click the Specify CMS Data Source button.

3. Select "Copy Data from another data source

4. The select the current database I am using in the "Get data from" and select the new db in the "Copy to the following datasource"

I appreciate that all the data will be destroyed in the target DB and everything should be copied and the system will be pointed to the new DB. Is that correct?

Is there anything else i should be concerned about?

Thanks,

Re: Changing CMS Database

Former Member — Tue, 28 Jan 2014 15:14:49 GMT

As i see you are planning to have a distributed DB. That means the system is growing up and you need a larger-scaled system.

Yeah all those steps are going to create all the db objects for your new db server and copy data from your existing db.

What i can add is you will need to create an ODBC connection at the OS level for your new DB where CCM is located before those steps. Then the connection will be ok and migration process will begin.

Regards,

Ceyhun

Re: Changing CMS Database

Former Member — Tue, 28 Jan 2014 18:09:10 GMT

The steps are perfect, just ensure you have the backup for Db available. nothing more that needs to be added.

Re: Changing CMS Database

Former Member — Wed, 29 Jan 2014 01:00:48 GMT

Hi,

Steps are fine.

Make sure that you have connectivity between new DB and BO.

Make sure that you have valid cluster key information.otherwise you will not be able to respoint the SIA to the newly copied DB.

Re: Changing CMS Database

Olj — Fri, 13 Mar 2015 16:46:25 GMT

Hi Prasad, can you help me, I want to "Copy Data from another data source" too, where is cluster key located?

Re: Changing CMS Database

Former Member — Fri, 13 Mar 2015 17:18:26 GMT

Who ever installed the BO, they should have that information. if you cannot find it, you can reset the password. Check below KB how to reset the cluster key.

              1613058 - How to change or reset Cluster key in a SAP BI4.0

Re: Changing CMS Database

Former Member — Fri, 13 Mar 2015 18:17:28 GMT

Stop SIA.

Right click and go to Properites-->Configuration tab. And you will see a section called: "CMS Cluster Key Configuration", you can copy that and paste it in a notepad and use it when ever you are chaning your CMS DB.

Thanks!