Schema Mapping

[Former Member]

I have a system where i have created few schema's.I want to replicate all the objects,views logics etc present in one schema to another schema of the same system.I want to know whether it is possible to do so ? If yes how can we do it and if no why ?

I have tried to perform schema mapping with 2 of my schemas but got an error message saying " Authoring schema already exists as physical schema choose a different schema".

I have attached a file of my error.

Please give me a solution to replicate data as well as know the difference between schema mapping and data replication

Thank you

[Former Member]

Hi Mahesh,

Perhaps there's a misunderstanding of the features present on HANA.

Schema mapping - works to map the schema used by the author of view to the consumer system. Example: I use schema XPTO and want deploy on a system where the equivalent is ZZZ, so during my development I use schema mapping XPTO = SAP_SOURCE and put on the instructions for deployment that you must map SAP_SOURCE to your schema, ZZZ on this sample.

Schema mapping don't move. Don't replicate.... Just map/point to... Due to this fact you are receiving the message because it don't make sense point to same thing.

I got confused of what you mean with "replicate". Do you want new objects pointing to the new schema? take a look on "Mass Copy" (Window -> Show View -> Other View -> Mass Copy)

Regards, Fernando Da Rós