Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Boris_Rubarth
Product and Topic Expert
Product and Topic Expert
I recently stumbled across the DMO dialog Database Migration Initialization for the parameters of the SAP HANA target database, and would like to share my experience with you on the parameter Target DB SID.

Note: readers should be familiar with Database Migration Option (DMO), as introduced with the blog https://blogs.sap.com/2013/11/29/database-migration-option-dmo-of-sum-introduction/.


So you know about DMO as migration scenario, and you understand that the SUM tool asks for the parameters of your SAP HANA target database. So what's the point?

The point is the parameter Target DB SID, and its relation to the system-ID of the ABAP source system.


The SUM tool fills the field with the value of your ABAP source system (not shown in screenshot). Question is now if this value is valid - and the answer depends on whether your SAP HANA target database is a single container or is using MDC: multitenant database container. See blog for details on MDC: https://blogs.saphana.com/2015/01/27/sap-hana-multitenant-database-containers/

Note: SAP HANA 2.0 is always MDC.


So the approach is:

  • If your target is a single container:
    You do not keep the value, but instead have to specify the existing system-ID of your SAP HANA database.
    SUM uses host name and instance number to connect to the database, and then checks if the system-ID is correct. So if use any other value, the tool will throw an error Wrong SID.

  • If your target is MDC / SAP HANA 2.0:
    You do keep the proposed value, and SUM will create a new tenant with that name in your SAP HANA database.
    You may use other values, even existing tenant names.

  • If you run "DMO with system move" [aspect added on May 14 '20, corrected on June 19 '20]
    You do keep the proposed value You provide the existing SID of the existing SAP HANA database, and SUM will re-create the tenant (which was created during provisioning of target PAS) with that name in your SAP HANA database


Note: this is independent on whether you use SUM 1.0 or SUM 2.0 (see blog https://blogs.sap.com/2017/08/10/sum-in-the-family-way/).
20 Comments