• SUM does not only offer to 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, only changes the database (host)
• To combine the database migration with a move of the system to a different environment, "DMO with system move" can be used
  
• Specifically for the conversion to SAP S/4HANA, DMOVE2S4 can be used as alternative for "DMO with system move"
  
• DMO allows an easy reset of the procedure at any point in time
• DMO supports the migration to 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 consider the potential changes by end users
• Downtime-optimized DMO can be combined with DMOVE2S4, but not with "DMO with system move"
• SUM 1.0 (for target systems based on SAP BASIS 7.40 and lower) allows to execute a Unicode conversion as part of the migration

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, while in parallel the SAP HANA database is setup (client, schema, …). Then the database connection of the SAP system is switched to the target 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 the target database. The source database continues to run and the application data in it are not modified, so it remains a fallback throughout the complete process.

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. The advantage is fast processing, as no dump files are created and no compression of files is required.

Consider the features and hints collected on the following separate SAP Support Portal page:

DMO Perfomance Optimization

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.

DMO Guides and dedicated sections

• Guide for DMO with SUM 1.1
• Guide for DMO with SUM 2.0
  • Performing DMO with System Move | SAP Help Portal
  • DMO Move to SAP S/4HANA (on Hyperscaler) | SAP Help Portal

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