cancel
Showing results for 
Search instead for 
Did you mean: 

Changing CMS Database

Former Member
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

olzhas_omarov
Participant
0 Kudos

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

former_member185603
Active Contributor
0 Kudos


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
           

Former Member
0 Kudos

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!

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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