Skip to Content

SMIGR_CREATE_DDL

Dear Friends,

Need some input regarding the SMIGR Program.

We are planning to migrate the our NW 7.02 ABAP+JAVA (GRC/NFE) system from AIX/Oracle to Linux/Oracle.

Before Starting the export, as per the System copy guide we have to run the Report SMIGR_CREATE_DDL.

When i run the report and i select target database option as Oracle and next to that there is option of Database version.

When i click F4 there i get there option.

1. Oracle -- Blank option

2. Oracle -- Special Option: Generate DDL with compresion

3. Oracle -- Special Option: Generate DDL for ALL Tables

Now here, i am bit confused, which option is should select for migration of my system. As there is no specific notes for giving complete descripition about this there option.

Can you anyone suggest which optionĀ  will be suitable for my migration scenario.

Thanks,

Anil Bhandary

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 07, 2013 at 08:22 PM

    Hello

    We are planning to migrate the our NW 7.02 ABAP+JAVA (GRC/NFE) system from AIX/Oracle to Linux/Oracle.

    You do not have to specify a database version there.

    You may read this SAP note

    888210 - NW 7.**: System copy (supplementary note)

    Program SMIGR_CREATE_DDL

               You do not have to specify a database version.

               When you make a homogeneous or heterogeneous system copy without changing the database platform, the necessary information about generating DDL statements is read directly from the system catalog. To do this, the system checks all database objects to see if the memory parameters differ from the parameters in the standard system. This applies, for example, to partitioned tables and bitmap indexes. Note 519407 describes how you can accelerate processing during the DDL generation.  Ensure that the cubes are correctly condensed (see Notes 407260 and 5900370) so that your system performance is optimal.

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Reagan Benjamin

      HI Team,

      As I am  working on the BW 7.31 /HANA to Bw7.4 Sp08/HANA.

      Before that i need to build a sandbox system. I am started working export and import method.

      When I am exporting it asking for the generation of the report SMIGR_CREATE_DDL. Is this step mandatory for the same DB for the source and target?.

      Please help me on this.

      Regards,

      Teja

  • Oct 15, 2014 at 08:37 AM

    Dear Teja,

    As per the best practice, you should execute the report.

    It will help to extract the non-database specific objects.

    Regards,

    Anil Bhandary

    Add comment
    10|10000 characters needed characters exceeded