Export/Import (Heterogeneous) System Copy Procedure

[davide1706]

Hello all,

I need to perform a DB migration from Oracle to ASE.

I understood that we need to execute an heterogeneous system copy.

The application server and DB are on the same host. And the new DB on ASE will also be on the same host...

However, I couldn't find any detailed procedure about this. Could you please guide me and highlight the points of attention I need to be careful of?

Do I have to first export the DB dump, then delete the Oracle DB and then import the DB dump using swpm?

Thanks in advance

regards,

David

[han_liu]

Hi David,
I think here you mean you want to use export/import method to install the new ASE database & application server and old Oracle & application server all in same host, am I right?
If that situation, there have an problem is that you cannot install the same SID system in the same host.
In system copy guide, you can find in chapter "Standard System – Setting Up the Target System" for the installation of the target system, this system copy guide describes only the system copy-specific steps in section Setting Up the Target System [page 74], but refers for all steps that are identical with a new system installation to the appropriate operating system and database-specific installation guide.

For target system installation is nearly same as install an new system, so as I mention previous, it cannot use same SID for the same host.

Hope this information will be helpful to you!

Best Regards,
Han

[davide1706]

Hi Han

Yes indeed you're right that's what I wanted to do. Migrate the Oracle db to an ASE DB. Only the DB should be migrated on the same host. DB is running on the same host as the app server.

Is it not possible to only reinstall a DB using the heterogeneous system copy?

By using the DMO option of the SUM, shouldn't we also perform a system upgrade at the same time as the DB migration?

[SJ1111]

Hello David,

please follow the instructions given in the System Copy Guides - Target Database other than HANA:

https://help.sap.com/viewer/30839dda13b2485889466316ce5b39e9/CURRENT_VERSION/en-US/14678bf6e9a04f4f9...

Here you can find, dependent on the OS you are using, the detailed descriptions of a Homogeneous and Heterogeneous System Copy.

Best Regards

Stefan Jakobi

Product Management CLM

[davide1706]

Thanks for your answer Stefan.

I already read this guide, but I don't see a use case when the DB migration has to be done on the same host.

Shall delete the source DB after the export and before the import? Or could I wait until the import on the target is done and then delete it ?

Thanks.

[SJ1111]

Hello Etienne,

you are right, for a Heterogeneous System Copy on the same host you need to use SUM DMO (Database Migration Option).

See this Blog: https://blogs.sap.com/2017/11/22/comparing-sap-migration-procedures-to-sap-hana-database/

And the documentation for SUM DMO:

https://help.sap.com/viewer/c4ebc2b5d928446180d9ad2667f11faa/1.0/en-US/8b1d697dac2c4e92a62e8dd492f49...

Or you start with Software Provisioning Manager and switch to SUm DMO after the preparation of the DB:

https://help.sap.com/viewer/6ffd9a3438944dc39dfe288d758a2ed5/CURRENT_VERSION/en-US/a77f704b07644806b...

"After you have completed DMO preparation, you can run DMO as described in https://support.sap.com/sltoolset System Maintenance Database Migration Option (DMO) of SUM SP<Number>"

Best Regards

Stefan Jakobi

Product Management CLM