Skip to Content
avatar image
Former Member

sap bods exporting jobs from one schema to another

I have developed some jobs in development repository.

The tables I have used from my source system are in schema named ABC.

now i want to move these objects to test repository.

But in test reporitory the database schema name is XYZ.

How can I achieve this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 13, 2015 at 10:48 AM

    You can use Alias in the datastore configuration.

    You can use multiple datastore configurations to define the same alias for different environments.

    For execution purposes, you can create a system configuration specific for a given environment (DEV, TEST, etc., ) to refer to the relevant schema.

    kind regards

    Raghu


    Alias Fig1.jpg (104.9 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 02:24 PM

    Hi swati,

    you could change the schema about the context menu of the table. Open the datastore tabs and right click on the tables. One menu point is change owner. With this option you could rename the owner/schema.

    Regards

    Severin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2015 at 02:54 PM

    Hi Swati,

    Screenshot as shared by Raghu does not provide a complete picture of the scenario. Actually you should have multiple comfiguration/s within the datastore, one for DEV,QA etc. each.

    Corresponding to DEV configuration put the schema name that you want against the Alias. Similarly, for QA configuration put the schema name that you want in that environment. Also, the Alias name should be the pattern that you actually want to over-write. This pattern is usually the schema name of the DEV environment, which you intend to change while you move the code from DEV to QA. Please see attached the screenshot for a better understanding.

    Please note that only one datastore configuration can be used at a time. i.e. either DEV or QA can be active at a time.


    DS_Alias_Usage.png (63.1 kB)
    Add comment
    10|10000 characters needed characters exceeded