
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.
Explore SAP supported system copy methods, including database dependent backup and restore and database independent export and import, plus R3 load and J load for homogeneous and heterogeneous migrations.
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.
Learn how Abap data classes map to database storage units, tables, and indexes, and how this mapping affects SAP system copy and storage consistency across databases.
Explore how SAP links data classes to database storage units across Oracle, Informix, and SQL Server, with hands-on demos of tables, table pools, and clusters.
Explore the differences between R3 setup and SAPinst, inspect their control files, and learn how to customize steps and labels to control export or import in SAP system copy.
Explore hands-on R3 setup and SAPINST basics in a demo, covering R3 file structure, editing steps with R3 Edit, and navigating XML and control files for SAP installation steps.
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.
Demonstrates generating and inspecting sdr and str files with the three load controller, connecting via putty to a linux oracle sap system, and examining apl zero.str and sapview.str definitions.
Learn how initial extent sizes for tables and indexes are configured in package.txt and XD files, with 1700 MB limits and R3 size check for target databases.
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.
Learn the structure and customization of CMD command files used by R3 load and import processes, including ICF and DCF references, dump locations, block size, and package handling.
Demonstrates how SAP export and import cmd files govern package data transfers and explains roles like src, icf, dcf, d8, doc, and ext for oracle imports.
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 a hands-on demo of DSK files, SDM and detailed files, used to export and import packages, track progress, and define restart points when a load ends in an error.
Explore how R3 load exports data into package.json dump files with block-level compression, checksum, and CMD-driven size and path controls for export and import.
Explain the structure of C files and dump files from R3 load, including header information, table blocks, and splits. Note how package.txt and stock files enable restarts and imports.
Learn how tab sql files store database specific properties for bw objects, and how sm_create_ddl_report generates db specific sql and sql files for cross-database imports.
Generate database sql files for SQL Server 2008 in SAP OS/DB migration by logging into SAP system, running SE38, executing S_CREATE_DDL, and reviewing de facto sqls and sql files lst.
Explore import and export log files to troubleshoot issues and understand what is captured, including package dot log files with three load processing logs.
Learn how migration monitor MIGMON controls and optimizes SAP OS/DB export and import to reduce outages, with on the fly adjustments of field processes and customizable templates and DPL files.
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.
Discover how packet splitting divides str files into smaller packages to run multiple R3 load processes in parallel, boosting export and import performance with Java or Perl splitters.
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.
Explore SAP web application server java system copy tools, including j load, r3 load, and java package control, and learn about size check and db size XML outputs.
Explore how j load, java package controller, and j check generate export and import job files and dump data, including metadata and sdf tracking.
Operate the Java Migration Monitor (JMIGMON) to load or unload the SAP Web Application Server Java database, enabling parallel export/import via network or standalone config, and interpret state files.
Learn how the Java splitter divides export and import work by splitting large packages and tables. It covers split size, split rules, column selection (the primary key), and metadata 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.