Difference Between Homogeneous Copy, Heterogeneous copy & DB Refresh

Updated May 18, 2018

1. System Copy/ Homogeneous Copy

It is used to setup a system similar to a PRD, QAS etc.
i.e. the system is completely build from OS, Database and R3 without changing OS or DB.

2. Heterogeneous Copy

When ever there is a change in OS or DB then it is said to be heterogeneous.

3. DB Refresh

It is the process of refreshing the data of one system by another system data.
(OS, DB, R3) remains the same but only database is refreshed.

The reasons for System Copy

Unicode Migration or Code Page Conversion

1. To setup a new system in the landscape (Only DEV and PRD exists, now we need to deploy QAS as a copy of PRD)

2. To change the hardware.

3. To move out from one OS to another or One DB to another DB which is called as OS/ DB Migration which needs to be carried under the guidance of Certified consultant.

4. While applying patches, Kernel Upgrade to test the objects with Production data.

5. System Copy is performed using export and import of the database.

STEPS for SYSTEM COPY

1. Source System
2. Use Installation Master DVD
- Use Additional Tasks
- System Copy
- Source System
- select database instance export
- specify typical
- specify Profile directory e:\usr\sap\sid\sys\profile
- specify the password if <sid>adm
- Specify the export location for Import.
Review the inputs and continue the import.

Comments

28 Jul 2017 7:26 pm Shalesh Singh Visen Helpful Answer

Homogeneous system copy means a system copy with all the database tables from one system to another system of same kind, like same os/db on both the systems.
A Heterogenous System copy is a copy from one system to another system of a different kind, like different os/db in either of those.

28 Jul 2017 7:27 pm Shalesh Singh Visen Helpful Answer

Homogeneous copy is done when the source and target system are on the same OS and Databse.
Heterogeneous Copy is done when the source and target system differ either in OS or Database. Any ONE difference needs a heterogeneous copy.Homogenous copy is done by export/import technique.Heterogenous copy is done by system migration. It is same as export/import except that it will ask for target OS and DB type and needs a key to be entered.OSS notes are applied using T-code SNOTE. Java stack level can be found at http://hostname.domain.com/500 goto system info to find the java stack level.