Solution : https://service.sap.com/sap/support/notes/888210 (SAP Service marketplace login required)
Summary :
SAP Note outlines procedural guidance for efficiently managing the homogeneous and heterogeneous system copies utilizing R3load across various database platforms such as DB2, MSSQL, ORACLE, among others. It specifies general prerequisites like SAP kernel WEB AS 7.0 setup and stresses the importance of utilizing updated migration tools like R3load and R3szchk. Pre-export tasks involve database-specific preparations, using SMIGR_CREATE_DDL to generate DDL statements for special database objects. Post-export, files need relocating to designated directories for R3load processing. After import, running RS_BW_POST_MIGRATION ensures proper reintegration of data and updates the system according to the new database specifications, emphasizing the role of connected SAP systems in successful data migration.
Key words :
/400bw-sys-db-db6 bw db2 universal databasebw-sys-db-mss bw microsoft sql serverbw-sys-db-ora bw oraclebw-sys-db-syb bw, mss yyyy = year mm = month dd = day hh = hours mm = minutes ss = seconds, sybase ase database platformhan-db sap hana databasehan-db-eng-bw sap hana bw engine priority correction, medium priority category installation information validity software componentfrom rel, components bw-sys-db-db2 bw db2, db6 1279882 r3load fastload import distorts special characters 1267419 table corruption, /osbw-sys-db-db4 bw db2, microsoft sql server 1640703 sap hana db-specific enhancements, sap note concerns sap hana db-specific enhancements, target sap sybase ase 1010854 sql error 7719 1658360 heterogeneous system copy
Related Notes :
| 1848005 | |
| 1738258 | System Copy for Systems Based on SAP NetWeaver 7.3/7.3 EHP1 |
| 1718576 | Migration HDB ==> anyDB |
| 1697865 | Homogeneous system copy: Change log of SAP HANA-opt. DSOs |
| 1691300 | SYB: Unpartitioned F fact tables for InfoCubes |
| 1658360 | Heterogeneous system copy: "column list already indexed" |
| 1657995 | Corrections for RS_BW_POSTMIGRATION |
| 1644396 | SMIGR: No data export for aggregate tables |
| 1640703 | HANA DB-spezifische Erweiterungen in RS_BW_POST_MIGRATION |
| 1634222 | BW Korrekturen für SMIGR_CREATE_DDL |
| 1620775 | DB6: Migration from Sybase and HANA |
| 1620515 | System Copy for Systems Based on SAP NetWeaver 7.3 EHP1 |
| 1593998 | SMIGR_CREATE_DDL for MSSQL |
| 1533143 | SP28:RS_BW_POST_MIGRATION doesnt convert PSAs of new DS |
| 1490839 | OBSOLETE: Hom./Het.System Copy for Syst. Based on SAP NW 7.3 |
| 1490838 | System Copy for Systems based on SAP NW 7.0 incl. EHP 3 |
| 1471910 | SQL Server Partitioning in System Copies and DB Migrations |
| 1401595 | Setting up a Teradata "Data Source" |
| 1386639 | Hom./Het.System Copy for SAP NetWeaver based on Kernel 7.2 |
| 1339717 | Hom./Het.System Copy SAP NW 7.0 incl. EHP 2 |
| 1319517 | Unicode Collection Note |
| 1317500 | Hom./Het.System Copy SAP NW 7.0 incl. EHP 1 SR1 |
| 1281430 | DB6: Check notes needed for SAP NW BW system copy to DB6 |
| 1279882 | |
| 1267419 | TABLE CORRUPTION WHEN USING LOAD + MDC + ROW Compression |
| 1259011 | Hom./Het.System Copy for SAP Systems Based on SAP NW 7.11 |
| 1238351 | Hom./Het.System Copy SAP NW 7.0 incl. Enhancement Package 1 |
| 1156514 | DB6: Possible data loss during system copy of SAP BI |
| 1149665 | RS_BW_POST_MIGRATION cannot be restarted during PSA |
| 1120872 | Hom./Het.System Copy SAP NetWeaver 7.0 SR3 |
| 1077644 | Heterog. system copy range-partitioned -> non-range-part. |
| 1054852 | Recommendations for migrations to MS SQL Server |
| 1042437 | Hom./Het.System Copy for SAP NetWeaver Based on Kernel 7.10 |
| 1035051 | Transportable tablespaces |
| 1014782 | FAQ: MaxDB system copy |
| 1010854 | SQL error 7719 |
| 996263 | Missing P indexes in E and F fact tables after migration |
| 970518 | Hom./Het.System Copy SAP NetWeaver 7.0 (2004s) SR2 |
| 965695 | SQL 2005 migration of partitioned E fact tables |
| 962124 | Syntax error during migration to SQL Server 2005 |
| 961591 | SQL error 1750 when you import during homogenous migration |
| 869407 | Partitioning on Microsoft SQL Server |
| 688647 | DB6: SAP BW and SAP NetWeaver BI Administration Tasks |
| 543715 | BW Migrations and System Copies for BW 2.0B / 2.1 Content |
| 1672367 | SYB: 7.30 Heterogeneous system copy with target Sybase ASE |
| 1904595 | |
| 1591424 | SYB: 7.02 Heterogeneous system copy with target Sybase ASE |
| 1697542 | SYB: 7.31 System copy with target Sybase ASE |