Skip to Content
avatar image
Former Member

Heterogeneous system copy from MSSQL to Oracle

Dear Experts,

I have performed ABAP+JAVA system copy R3load based from Oracle to Oracle and MSSQL to MSSQL platform.

Homogeneous system copy many times.

But this is first time i am perfoming an Export from MSSQL source system with r3load Export method .....My Target system is havign Oracle 10.2.0.2 software installed along with installation prerequisites.

But while Importing the same MSSQL Export ...I am not getting any option for heterogeneous system copy.

I am running on ECC6.0 windows platform and i also have generated Migartion KEY.

But where should i put this key.

I have gone through system copy guide many times but unable to understand Exact options to follow to Migrate to Oracle target system. Appreciate if anyone can give me detail steps i need to carry on Target system

Best Regards,

AjitR

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 19, 2008 at 09:31 AM

    Hi,

    during system copy on target system it ask for migration key.

    following from installation guides.

    -> On the Welcome screen of the SAP Installation Master DVD, navigate to the following folder

    according to the requirements of your target system: Additional Software Life-Cycle Tasks System

    Copy <database> Target System <Distribution option: Central System / Distributed System / High-Availability

    System> Based on <Stack option> AS ABAP and Java / AS Java / AS ABAP> .

    -> To install the target system, you follow the instructions in the SAPinst input dialogs and enter

    the required parameters up to the screen SAP System > Database - Select the Database Instance Installation

    Method. On this screen, you choose the option Standard System Copy/Migration (load-based):

    The SAP data dump from the MIGRATION EXPORT CD image that you created during the export is

    loaded in the newly installed SAP system database.

    regards,

    kaushal

    Edited by: kaushal malavia on May 19, 2008 3:05 PM

    Add comment
    10|10000 characters needed characters exceeded

  • May 19, 2008 at 01:19 PM

    > But this is first time i am perfoming an Export from MSSQL source system with r3load Export method .....My Target system is havign Oracle 10.2.0.2 software installed along with installation prerequisites.

    >

    > But while Importing the same MSSQL Export ...I am not getting any option for heterogeneous system copy.

    There is no such option. You export the system as usually but you give a different target database.

    > I am running on ECC6.0 windows platform and i also have generated Migartion KEY. But where should i put this key.

    This key is enter when you choose "custom" in the sapinst on the target system.

    > I have gone through system copy guide many times but unable to understand Exact options to follow to Migrate to Oracle target system. Appreciate if anyone can give me detail steps i need to carry on Target system

    Heterogeneous system copies require a certified migration consultant on site, otherwise you will loose support for the target system (see http://service.sap.com/osdbmigration).

    You also need to execute "SMIGR_CREATE_DDL" in the source system and put the resulting files in the ORA subdirectory of the export (see note 885441 - Common Migration Errors). Also make sure, you use the LATEST versions of R3load, R3ldctl and R3ta and the corresponding db-libraries. Also use the latest Oracle patches (10.2.0.2 + latest interim patches). To speed up data loading you can use "-loadprocedure fast" during the import.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11, 2014 at 10:45 AM

    Is the issue resolved ?

    I have same issue, import is failing before actual execution starts (During inputs phase).

    Any luck from your end.

    Rgards

    Narendra

    Add comment
    10|10000 characters needed characters exceeded