sap bods exporting jobs from one schema to another

[Former Member]

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?

[former_member211387 · Accepted solution]

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

[Former Member]

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.

[severin_thelen]

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