Skip to Content

Split BODS from Standalone server to Distributed


We have BODS/IS/DQM application and database on one server. I have to split and move DB to other node.

Here are some steps i am planning to follow.


Backup/restore CMS/Audit db to new server.

In SIA properties, choose copy option to move the SIA/CMS.


Backup/restore all repo dbs to new server.

in CMS, update repo connection info.

delete job server entry in AL_MACHINE_INFO and reconfigure job server to use new repo dbs.


Follow steps in 1773657/1863547.

DQM: ???

Please let me know if any steps are missing.

Also, let me know how to update DS datasource hostnames to new db server.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 07, 2020 at 01:48 PM

    Hi Praveen,

    I think the steps you provided are fine as these are the prerequisites for changing to Distributed system.

    Installing a total fresh applications to Distributed system is fine but distributing a pre-installed Stand alone is different, Many configuration related challenges may come during configuring.

    So I suggest do all the backups correctly, So that it will be easy to recover. then only proceed.


    • Take a backup of DSConfig.txt file from below location. As I think it also needs to be updated as well .

    C:\ProgramData\SAP BusinessObjects\Data Services\conf\DSConfig.txt

    • Also take backup of Tomcat folder. It might be effected too.

    Let me know if any challenges face during configuration, I will try to help.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.