Skip to Content
author's profile photo Former Member
Former Member

Unicode conversion and System Copy


I am going to perform a unicode conversion. The procedure mentioned in SAP service marketplace is to perform system copy, perform unicode pre-conversion steps, perform export with R3load and then import.

My question is if I perform a system copy from prod to sandbox, then perform unicode pre-conversion steps and export PROD with R3load, which will convert it to unicode, then when I do import, doesn't it duplicate the already existing non-unicode sandbox instance which was copied in the first step from PROD.

To summarize my question, I mean should I perform a system copy of non-unicode PROD to sandbox, or should I just created a empty database unicode sandbox instance and then import unicode converted exp files of PROD into this sandbox?

Kindly help me in this matter.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 20, 2006 at 04:43 AM


    You could theoretically do the export/conversion from your production system and build a sandbox. The problem with this option is that you have to be able to take the downtime of the export/conversion on the production system - this is why most people will do a copy to create the sandbox then do the conversion.

    Another reason for taking the copy route is that you have to do the unicode preparation before the conversion and must people do not want to do this in production first as it can be a lot of work.

    So I would suggest the copy to build the sandbox and then convert unless you are very familiar with the unicode conversion process.

    I hope this helps,


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Arun,

      It doesn't matter either way. If you do it before the upgrade to 2004s, then you probably only have an ABAP stack to think about. Converting after an upgrade just adds the BI JAVA (JAVA stack) handling - nothing too difficult but more steps.

      Another tip is that you can convert from Oracle 10 (from 9.2) during a unicode conversion if you have not done so already. This saves you a separate task and more downtime. 😊



  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2007 at 10:03 AM


    The final message from Mike on this thread just about answers my question but I want to confirm if:

    1. It is definately possible to perform a BW 3.x -->BI7 upgrade <u>without</u> a UNICODE conversion.

    2.In non UNICODE BI7 systems it is possible to install and run the Java stack functions without performance degradation

    3. In BI systems that have been converted to UNICODE it is possible to continue to load data from non-unicode R/3 sources

    4.When the UNICODE conversion takes place there is no increase in the overall size of the database.

    Quick answers to the above would be very much appreciated!!


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.