
What this course is about?
Understand SAP system copy concepts, including homogeneous and heterogeneous copies, OS and database variations, prerequisites, and SAP's migration services such as the SAP SDB Migration Service and Migration Check Service.
Learn Abap system copy tools for sap os/db migration, including loading and unloading with r3 load controller, and str, sdf, tpl, ext files, plus nonstandard objects via ddl.
Explore template (TPL) files in SAP OS/DB migration, covering their structure, customization, and how the R3 load controller uses TPL to generate SQL for creating and dropping database objects.
Connect to SAP system via putty and SSH, create a tpl directory. Run the load controllers and review CPL files for Oracle and SQL Server; note MySQL is not supported.
Explore the str structure files used in sap os/db migration, including package.json and sap view.str, and learn how the data dictionary feeds str and sdr files for tables and indexes.
Explore how to generate and validate size checks for SAP OS/DB migration using R3 size check, including SDB and SD calculations, file outputs, and XML reports.
Explore the structure and use of task (tsk) and statistics (sdf) files in R3 load during the SAP OS/DB migration, including file formats, status codes, and merge options.
Explore import and export log files to troubleshoot issues and understand what is captured, including package dot log files with three load processing logs.
Explore migration monitor options (MIGMON) for SAP os/db migrations, including FTP, network, socket, and standalone data transfer via McMahon, with properties and control files.
Learn how table splitting speeds SAP OS/DB migrations by dividing large tables into parallel, single-column primary-key where-clause packages with the R3 tool and its R3to hints.
Improve sap export and import performance by tuning parallel processes, preparing db size with r3 size check, using table and sdr file splitting, and optimizing sockets and hardware resources.
Learn how to verify a SAP system migration using migration checker, including packet, object, and table checkers, with setup requirements, commands, and outputs.
Learn to use mic time to analyze per-package export and import timings, generate HTML and XML reports, compare timings, and optimize data load and index creation.
If you want to be an expert at “SAP/OS DB Migration” or want to clear "SAP OS/DB Migration certificate" then it's required to understand various tools used for OS/DB Migration and also a practical understanding on how it works. Well then you are at the right place, as this course will help you achieve all these goals.
You need to have some experience as SAP BASIS consultant to understand the terminology used in this course and some basic understanding of Operating systems and Databases.