Skip to Content
avatar image
Former Member

Importing SAP HANA Backup to SQL Server

Hi Experts,

I am new in SAP (0 knowledge)...

We have clouds SAP HANA and I have given a task to import the database from SAP HANA to SQL Server.

I have the SAP backup which contain BID, BIP, DEV, PRD folder. Honestly I don't know where to start and which folder or files in their that I am going to use for importing.

Hopefully someone could help me. Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 01, 2017 at 05:55 PM

    Hi Lupin,

    If you need to migrate your system from HANA to SQL Server, you probably have to perform a OS/DB migration. Check the system copy guides at http://support.sap.com/sltoolset

    This will require an heterogeneous system copy with R3load, which will export all HANA database and you will later on import on SQL Server.

    It is not possible to directly import a backup taken on a database system onto another.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Lupin,

      They will export the data with R3load/SWPM and this can be imported into SQL Server later.

      If you have been asked by the SAP HANA Cloud team to provide this setup, then follow as they suggest. These guys know what they are doing :)
  • May 02, 2017 at 01:24 PM

    Hi

    Kindly refer the SAP note 1718576 - Migration from SAP HANA to another database system.

    Regards

    Sriram

    Add comment
    10|10000 characters needed characters exceeded

    • This note address an issue with BW DDL statements with report SMIGR_CREATE_DDL and not an how-to for OS/DB migration from SAP HANA to other databases. It does not answer or help the OP.

  • avatar image
    Former Member
    May 09, 2017 at 10:12 AM

    Hi luis

    I requested from HANA Team to export our database thru R3load/SWPM but they said they can't do it for Bobj system.

    I don't have a choice but to follow their suggestions. Thanks once again luis for your insights.

    Add comment
    10|10000 characters needed characters exceeded

    • Well, I didn't know your product was BOBJ. It is always important to make sure to tag your product or describe it. For all SAP systems based on SAP NetWeaver, R3Load/SWPM would be possible. I don't know how it works with BOBJ at this point. Good luck!