Skip to Content
avatar image
Former Member

HANA Migration from a Compressed Oracle Database

Hi Everyone,

We are planning to migrate our ECC environment from Oracle To HANA. Below are the details of our current environment:

Oracle:11.2.0.3.0

DB Size: 1.5 TB

We are planning to compress our Database first using OLTP TABLE compression and then migrate it to HANA.

I am confused with below line in note#1793345 - Sizing for SAP Suite on HANA

An assumption is that your source system is well-maintained and uncompressed

Please suggest if we are good to compress our database before migrating it to HANA or is there any issue when migrating compressed database to HANA.

Thanks for your support!!!

Regards,

Nikhil Goyal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 19, 2015 at 06:06 AM

    Hi Nikhil

    Why would you still want to compress the database before the migration? To me that doesn't really make sense.

    I assume the statement is there because the sizing guidelines (or scripts) don't take this compression into account. If you have a compressed database before migrating to SAP HANA, your compression rate moving from anyDB to SAP HANA will be lower.

    Kr

    Tom

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes, if you migrate your exisitng DB to HANA, then your new HANA DB will be in complressed format.

      The compression ratio cannot be calucated exactly. It depends on the many factors and type of the Application that you are migrating.  But however, according to my understanding you can expect 1:4 or 1:6 ~ compression ratio.