Skip to Content
avatar image
Former Member

Migrate database from HANA to SQL

Hi All,

Is there any tool to migrate database from hana to sql?

Thanks.

Yiu Chern

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 11, 2017 at 11:12 AM

    Hello Yiu - I have done this six times and have been unable to find any tools.

    What I have done to get the information out of HANA-Based SAP B1 into SQL-Based SAP B1:

    1. Defined with the Customer what data was really important. (Base, Master, Complex, and Transactional).

    2. Developed a task list of data to be pulled and estimated my hours based upon the above.

    3. Used Query Generator to pull all pertinent tables from HANA-based SAP B1 (Like OSLP, OITG, etc for Base Data, OCRD, CRD1, etc. and OITM, ITM1, etc. for Master Date, and ORDR, RDR1, etc. for transactinal data).

    4. Used DTW to get the data into SQL-based SAP B1. You might want to check the SAP B1 User Guide with "Data Migration and Opening Balances" as a good starting point to make sure you are going in the correct order.

    That is really high-level, but you get the jest of it - the whole activity was basically doing a new implementation into the SQL-based SAP B1.

    If you find some tools, let us all know - please...

    Thanks much and take care - Zal

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 23, 2017 at 06:09 AM

    + realy needed

    Add comment
    10|10000 characters needed characters exceeded