http://scn.sap.com/docs/DOC-49580
Database Migration Option (DMO) of SUM Introduction created by Boris Rubarth on Nov 29, 2013 1:14 PM, last modified by Boris Rubarth on Jul 10, 2014 6:31 PM Version 20 inShare5
Scenario:
You want to migrate your existing SAP ABAP system to the SAP HANA database
Your SAP release needs to be upgraded prior to migration Use the database migration option (DMO) of the Software Update Manager (SUM): it combines SAP upgrade and database migration to SAP HANA in one tool!
Benefits:
Migration steps are simplified
System update, Unicode Conversion, and database migration are combined in one tool
Business downtime is reduced
The source database remains consistent, so a fast fallback is possible Motivation If you want to migrate an existing SAP system (running on anyDB) to a SAP HANA database, required steps may be a dual-stack split, a unicode conversion, conversion, a database upgrade of anyDB anyDB,, an upgrade of your SAP software, and a database migration to SAP HANA. The Software Update Manager (SUM) includes an option that combines the upgrade with the database migration "database migration option" (DMO) for SUM. It is sometimes referred to as the one-step migration procedure, compared to the classical migration (i.e. heterogenous system copy, using Software Provisioning Manager). The DMO is an inplace-migration (instead of a new installation): it upgrades and migrates the existing system while keeping the systemID, host name, and connectivity settings stable.
DMO for SAP NetWeaver BW and for SAP Business Suite systems DMO is available with Software Update Manager 1.0 SP09, and can be used for systems based on AS ABAP. It can be used for SAP NetWeaver BW systems systems from 7.0 SP17 (and higher) to migrate migrate to 7.31 7.31 (and higher). higher). And it can can be used for for systems systems part of the SAP
Business Suite 7.0 (and higher) to migrate to a level corresponding to SAP BASIS 7.40 (for example "SAP enhancement package 7 for SAP ERP 6.0"). DMO processing overview The processing sequence is based on the shadow system functionality of SUM: the SUM creates the shadow repository on the traditional database until downtime phase, while in parallel the SAP HANA database is setup (client, schema, ...). Then the shadow repository is copied to SAP HANA, the database connection of the SAP system is switched to SAP HANA database, and then the downtime starts. After migration of the application data (including data conversion), the upgrade is finalized and the SAP system runs on SAP HANA. The traditional database continues to run and it is not modified at all, so it remains a fallback throughout the complete process. DMO is using SAPUI5 Althought DMO is based on the "standard" SUM, a new user interface (UI) is used - but only for the DMO procedure. The UI is based on SAPUI5, so it's running in a browser, and offers some comfortable features like checking the log files without having to log on to the OS of the application server. The new UI is currently only available for the DMO procedure, but in the long run, it may become available for other use cases as well.
Please note that for a SAP Business Suite system based on SAP NetWeaver 7.40 (i.e. systems part of SAP Business Suite 7 Innovations 2013), your SAP NetWeaver Hubs must be on 7.30 or higher. For details, seehttp://wiki.scn.sap.com/wiki/display/SLGB/Strategy+beyond+SAP+Business+Suite+7+Innovations+20
11
Further information SAP Notes
SAP Note 1813548 Database Migration Option for SUM DMO Documentation Use the quicklink /sltoolset in SAP Service Marketplace, choose "SL Toolset 1.0", scroll down to the table of documentation, open section "system maintenance" SAP First Guidance - Migration BW on HANA using the DMO option in SUM Blogs on DMO
Migration to SAP HANA: Overview Video of Database Migration Option DMO
DMO: introducing the new UI
DMO: technical background
DMO: comparing pipe and file mode for R3load
Phases behind DMO R3load parallel export/import during UPTIME and DOWNTIME to target HANA DB
Blogs on related topics
Migration of SAP Systems to SAP HANA
A better way to migrate your SAP NetWeaver BW from any database to SAP HANA
Decision Matrix to Choose Best Migration Option of ABAP Systems to SAP HANA
Software Update Manager (SUM): introducing the tool for software maintenance
Best Practice Guide - Classical Migration of SAP NetWeaver AS ABAP to SAP HANA
http://wiki.scn.sap.com/wiki/display/SLGB/Strategy+beyond+SAP+Business+Suite+7+Innovations+2011 SAP Education offering
HA250: "Migration to SAP HANA using DMO" - two days classroom training Watch out for more details in further blogs that will be listed here as well. Boris Rubarth Product Management, Software Logistics, SAP AG 17466 Views Categories: Downtime Minimization, System Copy & MigrationTasks: migration Tags: sl_toolset , software_logistics , software_logistics_toolset, sum_tool, sum, software_update_manager ,downtime_minimizat ion, dmo, downtime_optimization
Average User Rating (8 ratings)
inShare5
48 Comments
Srinivas Kakarla Dec 3, 2013 2:26 PM
Thanks Rubarth, for the details. I am currently taking first steps in exploring DMO option for migration to SAP HANA and your latest blog is more than a handful resource. Thanks much. Srinivas K. Like (1)
Walter Castagno Apr 3, 2014 5:25 PM
Hi Boris, very nice presentation! I can use DMO also without HANA as a target? For example, to perform a migration of ERP 6.03 from Windows as s.o. and Oracle as db, to Linux Suse as s.o. and Oracle, with upgrade to ERP 6.06 in one step? Thank you Regards, Walter Like (0)
o
Boris Rubarth Apr 3, 2014 5:28 PM (in response to Walter Castagno)
Hi Walter, indeed this procedure is exclusively for SAP HANA DB as target db only. Regards, Boris Like (0)
Walter Castagno Apr 3, 2014 5:45 PM (in response to Boris Rubarth)
Ok! The possibility to not change hostname and the SID allow you to use the same application server with hana, then you not need to buy another server! This is a great solution! But is it also possible to do a real migration? I mean at the end you have the database in HANA and the PAS installed in another server that you specify during the procedure. (then the source system is only stopped, if you start it you can use it)
Thank you Regards, Walter Like (0)
Boris Rubarth Apr 3, 2014 5:54 PM (in response to Walter Castagno)
Hi Walter, not sure if I understand your scenario ... DMO is a real migration. System-ID is not changed, host of primary application server is not changed, "only" database host is changed - and database type, of course :-) So you do not specify the PAS server during the procedure, but you start the SUM for DMO on the PAS host. The source system does not exist after the migration, so it is not the source system that is stopped, but the source database that is no longer used. I think the blog on DMO technical background is helpful to check the architecture: DMO: technical background Regards, Boris Like (0)
Walter Castagno Apr 3, 2014 6:28 PM (in response to Boris Rubarth)
Hi Boris, I checked your post "DMO: technical background". I'm sorry, my question is not clear, I try to explain. After the migration to HANA my goal is to have 2 systems: - the source system of the migration that is unchanged and available for user. - the target system, that is HANA DB + PAS installed in a new server created for thi purpose. I don't know if DMO allow this possibility or I have to use SUM (obviously not in one step). Thanks Walter Like (1)
Boris Rubarth Apr 3, 2014 6:55 PM (in response to Walter Castagno)
Hi Walter,
DMO switches the database, but keeps the application server stable
a system is a combination of a database with one (or several) application server; "application server" in the sense of software (instances)
with DMO you will have only one application server, so only one system at a time: either the new one or the old
your scenario to have 2 systems afterwards is rather a copy and an update (with migration), not a pure migration; so even with the classical migration, you will have to do a copy first, and then update one of the systems Does that fit to your concerns? Regards, Boris Like (0)
Walter Castagno Apr 3, 2014 6:58 PM (in response to Boris Rubarth)
Yes!! Thank you for the information! Regards, Walter Like (0)
Boris Zarske Apr 4, 2014 9:06 AM (in response to Walter Castagno)
Hi Walter, For the classical approach, you can find more information on this page. Best regards, Boris Like (0)
Walter Castagno Apr 4, 2014 6:02 PM
Hi Boris, another scenario: I want to migrate my SAP system to HANA and migrate also the o.s (eg. from windows to linux). I can use DMO with the process described in your post to obtain my system WITH DB on HANA and PAS on windows. Can I turn off definitively the PAS and install a new PAS on linux (new server) on top of HANA DB ? Thanks Regards, Walter Like (1)
o
Boris Rubarth May 9, 2014 2:59 PM (in response to Walter Castagno)
Hi Walter, sorry for the delay ... not sure what the overall scenario is. I can only answer concerning DMO: DMO can not "turn off the PAS and install a new PAS on linux".
Regards, Boris Like (0)
o
Roshan Ramachandran Jun 30, 2014 12:58 PM (in response to Walter Castagno)
Hi Walter Castagno ,
I have the exact same scenario as you had asked Boris Rubarth. I want to migrate my SAP system to HANA and migrate also the OS of PAS/App server (eg. from windows to linux).
As you have already tested the DMO, can you please let me know whether this is possible with DMO? If this is possible, will the source system (with PAS on Windows) be usable after migration?
Thanks, Roshan Like (0)
o
Roland Kramer Jun 30, 2014 1:20 PM (in response to Walter Castagno)
Hi Walter, Yes, of course you can do so. Best Regards Roland Like (1)
Walter Castagno May 9, 2014 6:50 PM
Hi Boris, thank you for your reply! In the mean time, I've tested DMO tool successfully!! Only one doubt: in a TechEd2013 presentation (ITM212) I saw that DMO support nZDT Maintenance capabilities but during my test, in "Advanced parameters for the procedure" the tool says that nZDT Maintenance capabilities are not supported for database migration and then are not used. Im' a little bit confuded :-) Do you know what is the correct information and, if not supported, in future will be supported nZDT Maintenance with DMO? Thank you for you help Regards, Walter Like (0)
o
Roland Kramer May 9, 2014 7:23 PM (in response to Walter Castagno)
Hi Walter, Unfortunally all nZx technologies available for SUM natively, are not available with the DMO option due to the database migration option procesure itself. Three things to know when migrating SAP BW on SAP HANA Best Regards Roland Like (0)
o
Boris Rubarth May 14, 2014 11:05 AM (in response to Walter Castagno)
Hi Walter, indeed nZDM in SUM is not available for the DMO procedure, that is why you have seen the information on the screen: something like "nZDM not supported".
Background: the nZDM option is only visible when choosing the preconfiguration mode "Advanced", see blog Settings to activate downtime minimization capabilities in SUM - but for DMO, the option is not offered, so when choosing mode Advanced, a text is displayed to explain that nZDM not supported with DMO Please note that we distinguish between nZD M (near Zero Downtime Maintenance) which is an option for SUM and nZDT (near Zero Downtime) which is a service offering (see SCN document). The slide in ITM212 explained the nZDT approach, which may be combined with DMO, but this does not mean that "with nZDT, nZDM in SUM is used for DMO". For DMO, we hope to offer a similar approach like nZDM for SUM in the future - stay tuned. Best regards, Boris Like (0)
Walter Castagno May 14, 2014 2:44 PM (in response to Boris Rubarth)
ok, I was a little bit confused between nZD M and nZDT but now it's clear! Thank you for your answer!!! Regards, Walter Like (0)
Luis Carranza Jun 13, 2014 8:05 PM
Hi Rubarth: In the SAP Presentation "Migration to SAP NetWeaver Business Warehouse on SAP HANA – Best Practice Update 2014" I saw that DMO can be used to: 1) Upgrade BW 2) Migrate BW from Any Database to HANA 3) Move BW on Premise to HANA Enterprise Cloud in a single step (slide 14 of the file). For this option the process is move the CI from the On premise data center to the cloud and then run DMO from that instance. We are interested on that option but I have not been able to see more information on it. Do you know where I can get more information on this option?, Do you have any comments/suggestions on it? Thanks Luis Carranza Like (0)
o
Boris Rubarth Jun 17, 2014 11:23 AM (in response to Luis Carranza)
Hi Luis, sorry to tell you that there are no further information available, as this procedure (move to HANA Enterprise Cloud) will be conducted by SAP colleagues during the project anyhow. Regards, Boris Like (0)
o
Roland Kramer Jun 17, 2014 2:14 PM (in response to Luis Carranza)
Hi Luis, for the motivation, you can check the following Document - Overview - SAP HANA and SAP NetWeaver AS ABAP o... | SAP HANA to do this, use the SWPM and Install the CI to the HANA applicance, where it may fit. for Example on a single node create the default file system for your ABAP system and do the memory settings for HANA to ensure to have enough memory for the Primary Application Server.
depending on your existing OS for your "old" Primary Application Server , you have to choose now Linux X64 as OS now. You can have mixed CI/DI Installations depending on that. This is independig either you do this in your on premise, or in the possible cloud Landscape. Best Regards Roland Like (0)
Luis Carranza Jun 18, 2014 3:24 PM (in response to Roland Kramer)
Hi Roland, Boris: Thank you for your replies. 1) Is this option available to move the system from on premise to the HANA cloud in SAP only or can be used to move BW from on premise to any Cloud provider (basically we are planning to upgrade, migrate to hana and move from on Premise to IBM cloud (another data center)). 2) For this DMO option, do I need to move to the cloud the instance having message server and enque server (ASCS) and also install on the cloud a Dialog server, or just installing on the cloud a PAS with DIA and BTC processes will be enough leaving ASCS on Premise Thanks
Like (0)
Alex Taylor Jun 19, 2014 12:58 PM (in response to Roland Kramer)
Roland, Do you have any idea of the PAS footprint on the HANA resources??? Also I have found documentation to say that the PAS can sit on the HANA appliance for BAU in a standalone deployment but I can't find if this is supported in a scale out deployment??? Regards Alex Taylor (Was on the DMO course @SAPLand the other week). Like (0)
Roland Kramer Jun 20, 2014 12:14 PM (in response to Alex Taylor)
Hi, See the Comment above. No Idea about the scale out scenario. Best Regards Roland Like (0)
Luis Carranza Jun 20, 2014 4:31 PM
Hi Roland: Could you help clarifying these points about the DMO option of moving the CI to the cloud and run DMO from it to migrate BW from on premise to the Cloud at the same time of migrating BW to HANA? 1) Is this option available to move the system from on premise to the HANA cloud in SAP only or can be used to move BW from on premise to any Cloud provider (basically we are planning to upgrade, migrate to HANA and move from on Premise to IBM cloud (another data center)). 2) For this DMO option, moving CI means moving to the cloud the instance having message server and enque server (ASCS) and PAS, or just installing on the cloud a PAS with DIA and BTC processes will be enough leaving ASCS on Premise? Thank you for your help Luis Carranza Like (0)
Andrew Greig Jul 25, 2014 1:55 PM
Hello, can anyone tell me if there is a way with the new UI for the DMO of SUM whether I can set up an alert action (e.g. running a script to send an email) to be triggered when the process has stopped awaiting user input ? This was a very useful feature available with the old Software Update Manager interface. Thanks. Like (0)
o
Francois Keen Jul 29, 2014 12:59 AM (in response to Andrew Greig)
Hi Greig I asked the question some time ago to Boris [SUM 1.0 SP11 wasn't yet released at that time], and the answer was no. So, I ended up setting up a crontab script looking for the file /usr/sap/put_/SUM/abap/tmp/upalert.log, if the file existed then the script would send an email alert with the contents of the file in the email body,,, This is obviously not as reactive as the "old" non-DMO SUM but it is a workaround... Hope this helps.
Cheers Francois Like (0)
Weerawat Kitipornchai Aug 12, 2014 11:44 AM
Hi Boris, Can I use DMO to migrate the system to HANA without any Software Update, i.e. the system is already on the latest Support Stack? Regards, Kit Like (0)
o
Srinivas Kakarla Aug 12, 2014 11:49 AM (in response to Weerawat Kitipornchai)
Kit, No, you need to SWPM for migrating your Source instance to SAP HANA if its already on the required Netweaver stack. This will fall under Classical Migration of SAP ABAP systems to SAP HANA. The software update and migration is integrated process in DMO UI and there is no option to choose either one of them. Hope this helps. Regards, Srinivas K. Like (0)
Aravind sap Sep 1, 2014 6:06 AM
Dear Boris and DMO Experts, I'm sorry if i am asking a weird Question. During the DMO configuration phase target HANA DB SID was given wrong by mistake, now i have spent lot of time and efforts to bring DMO to preprocessing phase, i looked at all the files to see if i can edit any config file like Keydb.xml to correct and i am not able to find. Is DMO smart enough to identify and give me an option to modify/correct my input later point of time ? Please advise Thanks, Aravind Like (0)
o
Roland Kramer Sep 1, 2014 11:42 AM (in response to Aravind sap)
Hi, DMO is an integrated part of SUM, so there are no kexdb.xml file(s) at all. Instead yo have several configuration files, which are described in the DMO Guides lik ehttp://scn.sap.com/docs/DOC46824 or https://service.sap.com/~sapidb/011000358700000950402013E/SUM_SP11_DMO_RTC_13.pdf Best Regards Roland Like (0)
o
Boris Rubarth Sep 1, 2014 1:50 PM (in response to Aravind sap)
Dear Aravind, the system-ID (SID) of the target SAP HANA database is used for the connection from SAPup to the SAP HANA database. If you enter a wrong SID, the connection will either not work (and you'll get a connection error), or it will connect to that database, which seems to be the case in your scenario. So you will have to reset the DMO procedure to withdraw any changes, and start again, now specifying the correct SID. Regards, Boris Like (0)
Aravind sap Sep 1, 2014 5:41 PM (in response to Boris Rubarth)
Dear Boris, Thanks for the response. I am trying to see if there is any alternative instead of doing a reset of DMO. Can SAP SID and HANA SID be the same ? I see only license issue will come as we can not have two SID's , but system should work. Is license key during the migration is mandatory ? Thanks, Aravind Like (0)
Srinivas Kakarla Sep 1, 2014 5:48 PM (in response to Aravind sap)
Aravind, If SAP PAS and HANA are running on different servers, then you can maintain same SIDs. But if you are looking to install SAP PAS on the same HANA server then you have to maintain different instances. Refer to OSS ntoe 1953429 for moe details on this. Hope this helps.
Regards, Srinivas K. Like (0)
Ravindranath Gangampalli Sep 2, 2014 2:54 PM (in response to Srinivas Kakarla)
In this case how do you generate license key's for two same SID's ? You can have only one unique SID. Like (0)
Srinivas Kakarla Sep 2, 2014 2:58 PM (in response to Ravindranath Gangampalli)
Ravindranath, The SAP License generation involves the following components: - SAP System ID (SID) - SAP Component - Hardware Key - Instance number
- Custimer number Both SAP Component and Hardware key will be different for SAP Netweaver PAS and SAP HANA. Hope this helps.
Regards, Srinivas K. Like (0)
Ravindranath Gangampalli Sep 2, 2014 3:11 PM (in response to Srinivas Kakarla)
I understand that, But can you generate two license keys with the same SID? To my understanding you can not have two SID's in the landscape, they should be unique and you wont be able to generate license keys . HANA DB license key request needs amount of memory. DMO will ask for license key during the migration, after migration which license is showed in slicense? i can check this myself may be in other two days , my migration is in middle. Thanks, GR Like (0)
Srinivas Kakarla Sep 2, 2014 3:45 PM (in response to Ravindranath Gangampalli)
After migration the SLICENSE will show the Netweaver license for HDB database. Maintaining same SIDs is an option but not mandatory, and you can go with the best practices you are currently following. Srinivas K. Like (0)
Julius Kaplan Sep 12, 2014 1:14 PM
Boris
so you have to have a brand new HANA database installed in another server? For a while you will have 2 databases running at same time? Until you deactivate the old MSSQL as on my case? My problem is that DEV and QAS will still be on MSSQL... mgmt wants only PRD running on HANA. I'm not confident that it will work out. Do you have any expertise to share on this scenario? Like (0)
o
Boris Rubarth Oct 14, 2014 10:55 AM (in response to Julius Kaplan)
Hi Julius, I guess it is generally recommended to have a homogenous landscape. Furthermore, QAS testing cannot be used to identify / predict potential issues in production if the underlying database is different. And I am not sure what happens if HANA-optimized objects (e.g. Info-Cubes) are overwritten by change requests originated from a BW system on a non-HANA database. Regards, Boris Like (0)
o
Boris Rubarth Oct 15, 2014 10:30 AM (in response to Julius Kaplan)
For SAP BW systems, check out SAP Note 1808450 "Homogenous system landscape for on BW-HANA" Regards, Boris Like (0)
Luis M Carranza Sep 12, 2014 7:28 PM
We are running the DMO option of SUM to upgrade our BW system to 7.4 and migrate it to HANA DB. We are using SUM version SP11 We are close to being the downtime portion of the process, but during the initial phase we selected the option to "compare content of ALL tables (target vs Source DB). We now realized that maybe was not a good selection since this could add too much time to the process and maybe adding some room for errors there. The database is not too big, it is only 400 GB in the legacy DB. Is there a way to change that option to "Do not compare table contents" without resetting the upgrade and repeat from the beginning? As I said we are close to beginning of downtime, so we do not want to repeat the whole process. Thanks Luis Carranza Like (0)
o
Ravindranath Gangampalli Sep 13, 2014 11:55 AM (in response to Luis M Carranza)
Hi ,
Please see Phases behind DMO R3load parallel export/import during UPTIME and DOWNTIME to target HANA DB
That explains uptime and downtime phases which includes table count. as far as i know there is no option in DMO to change the table compare option, you can only change number of parallel process during the DMO runtime. Like (0)
o
Boris Rubarth Sep 16, 2014 4:50 PM (in response to Luis M Carranza)
Hi Luis, just to confirm what Ravindranath has already written: there is no way to change the table compare option. "Compare ALL tables" should only be used for a test run. Regards, Boris Like (0)
Aziz Dohadwala Sep 13, 2014 11:26 AM
Thanks for the details. Quite a bit to consider. Extremely helpful presentation
Thnx, Aziz Like (0)
Ravindranath G angampalli Sep 13, 2014 12:01 PM
Dear Boris Rubarth I have come across a situation where DMO hangs when i click on any of the upcoming phases . I was trying to see how many current steps remaining in current phase and by mistake when i clicked on one the steps which din't finish , DMO activated check mark until that phase and stops there. I had to restart DMO and continue from the last phase.
Normally we can click on phases and scroll down in SWPM, but in DMO case it is not working.
Is it normal , Please advise
Thanks, GR Like (0)
o
Boris Rubarth Sep 15, 2014 9:49 AM (in response to Ravindranath Gangampalli)
Dear GR, where is that phase list (you have clicked into) located in the UI? The phase list on the right hand side shows the phases of the current roadmap step, and a click on a phase name will open the respective log, if existing. But the DMO run will then not stop at this phase. The Utilities / breakpoint menu shows the phaselist as well (for all roadmap steps). Marking the checkbox for a phase creates a breakpoint. When the phase is reached you can simply continue the procedure, using the continue option on the UI. Regards, Boris Like (0)
Ravindranath Gangampalli Sep 15, 2014 10:19 AM (in response to Boris Rubarth)
Dear Boris, Thanks for responding. Yes, I am talking about the phase list which is located in right hand side of the UI. I did not set any break points during the migration. It happened to me two times during the migration, when ever i clicked on one of the phases in phase list (which is not yet finished) DMO puts a check mark on all the phases till the one phase that i clicked and it stops there. Once i reboot DMO i can continue from the Original phase it was running. Thanks, GR Like (0)
Boris Rubarth Sep 15, 2014 1:08 PM (in response to Ravindranath Gangampalli)
Dear GR, our guess is that the click in the phase list could have stopped the automatic refresh of the UI (not the run itself), and a manual browser refresh (F5) may have solved the issue.
Regards, Boris
