Skip to Content

How to change Database server name for datastore in SAP Data Services Managment Console?

We are migrating SAP BODS 4.2 from old environment (windows 2008) to new environment (windows 2012), we have followed the instructions present in the upgrade guide (ds_42_upgrade_en.pdf) under "Migrating Data Services to a new environment". we have changed database server name in the Data Services Designer for Datastore, but the same we are not able to see in SAP Data Services Management Console. when we change the database server name and apply it in management console it wont reflect and it reverts back to old database server name. could you please suggest us what we are missing here?

Thanks,

Alankar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 11, 2017 at 10:06 AM

    We have solved this issue, what we did was changed the machine name and reserved name in AL_MACHINE_INFO table in each of the database's restored then changed the DB Hostname in management console. and it solved our issue

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2017 at 11:35 AM

    I assume you're referring to datastore definitins in the local object library, correct?

    Easiest way to switch a datastore to another database is by defining a 2nd configuration and making that the default. You can delete the original one afterwards. The updates will be automatically reflected in the DS management console.

    Add comment
    10|10000 characters needed characters exceeded