on 12-07-2013 7:13 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Reagan,
I had been gone through that note. But i am still confused. Then why that special options are there in Database version.
1. Any specific compoenent for which we have to select that one of the spcial option or there any specific usage of that Special options in Database version.
2. In my case which option you suggest, i should select .... I should keep database version as blank or i should select any one of the option out of 2 of them of special option.
Regards,
Anil Bhandary
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.