here some hints:
For P360 if you keep the names it can be used as it is otherwise the DB Update should run again to recreated the indexes and so on. For example old DB PIM_MAIN_PROD and the new one PIM_MAIN_TEST, the scripts should be executed again.
MAM is a bit more complex because it will not work if you only copy the DB. Important is to remember the PW for OPASUSER and OPASPUBLIC from the old installation, otherwise it will not work. (PWs are in the installation LOG)
Also if the DB is copied be sure that this both Users are created with the same rights and permissions as in the old DB, otherwise it will also not work and you will get strange Errors.
Thank you Ralph, we have decided to have the same schema name only change will be Database server name will be changed and service name. Can you please let me know what all changes we need to make for only Server name and Service Name.