-
Request for existing cases, user IDs, Portal navigation support and more
Database Migration Option (DMO)
DMO of Software Update Manager (SUM) in a nutshell
- SUM can not only update software components, but can also execute a database migration (for ABAP based systems)
- DMO (Database Migration Option) is the combination of software update with the database migration
- To only migrate the database (without software update), the approach "DMO without system update" can be used
- The standard DMO is an inplace-procedure, as it keeps the Application Server level unchanged, it only changes the database (host)
- In addition, DMO can be used for move scenarios in which a transition of the complete system to a different environment is possible:
"DMO with system move", and "DMOVE2S4" (specifically for the conversion to SAP S/4HANA) - DMO allows an easy reset of the procedure at any point in time
- DMO supports the migration to target database type SAP HANA DB, and (depending on scenario) to other database types as well
- To reduce downtime, the approach of downtime-optimized DMO (also called uptime migration) can be used,
it will migrate selected large application tables already in uptime, and will consider the potential changes by end users;
Downtime-optimized DMO can be combined with DMOVE2S4, but not with "DMO with system move" - SUM 1.1 (for ABAP target systems based on SAP BASIS 7.40 and lower) allows to execute a Unicode conversion as part of the migration
DMO processing overview
The processing sequence is based on the shadow system functionality of SUM: the SUM creates the shadow repository on the target database until downtime phase. Then once the downtime starts, the database connection of the SAP system is switched to the target database. After migration of the application data (including data conversion), the upgrade is finalized and the SAP system runs on the target database. The source database continues to run and the application data in it are not modified, so it remains a fallback (via the SUM RESET function) throughout the complete process.
Data Migration by R3load
SUM delivers its own R3load tool which is used for the migration of the application table content. SUM starts several R3load pairs that work on buckets (work packages) to export data from source database and import data into target database. As both R3loads of a pair are running on the same host, they can directly exchange data using the pipe mode of R3load (not true for "DMO with system move"). The advantage is fast processing, as no dump files are created and no compression of files is required.
DMO Performance Optimization
Consider the features and hints collected on the following separate SAP Support Portal page:
Reducing downtime with uptime migration
With SUM 2.0, it is possible to further reduce the downtime of a migration by using the approach of "Uptime Migration", also known as "downtime-optimized DMO". See SAP Note 2547309 for details.
More Information
DMO Guides and dedicated sections
Blogs on DMO
- DMO: technical background
- DMO: background on table split mechanism
- DMO: comparing pipe and file mode for R3load
- DMO: table comparison and migration tools
- DMO: Handling table comparison checksum errors
- DMO, SAP HANA and the Target DB SID
- Short history of DMO
Blogs on other DMO use cases:
- DMO without software change
- DMO with System Move – the use case to change PAS host during DMO
- Your SAP on Azure – Part 2 – DMO with System Move
Blogs on DMO downtime aspects:
- Optimizing DMO Performance
- DMO: introducing the benchmarking tool
- DMO: downtime optimization by migrating app tables during uptime
- 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
- Comparing SAP migration procedures to SAP HANA database
- Decision Matrix to Choose Best Migration Option of ABAP Systems to SAP HANA
- Software Update Manager (SUM): introducing the tool for software maintenance
SAP Education offering
- HA250: “Migration to SAP HANA using DMO” – two days classroom training