HANA database Restore on MS SQL Server

[Sajid_Islam]

Hi Experts,
We have clouds SAP HANA and I want to restore SAP HANA to SQL Server.
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
Sajid Islam

[riccardo_cola]

Hi,

[riccardo_cola]

Hi,

The migration of a SAP HANA database system to a 'SAP NetWeaver release 7.0x/7.xy on Microsoft SQL Server (Enterprise Edition)'  is supported through the SAP System Copy process.
The Installation and System Copy guides for SAP NetWeaver 7.0x/7.xy release can be downloaded from 'Software Provisioning Manager':
https://support.sap.com/en/tools/software-logistics-tools.html

Regards,
Riccardo

[fabiobilicki]

Install a VM with HANA for free, you can restore it to it, you have it in SAP Developer for you to download, you don't need to convert anything.

[riccardo_cola]

Hi,

The migration of a SAP HANA database system to a SAP NetWeaver/Microsoft SQL Server 'Enterprise Edition' system is supported through the SAP System Copy process (Heterogeneous OS/DB system copy).

The Installation and System Copy guides for "SAP NetWeaver release 7.0x/7.xy on Microsoft SQL Server" can be downloaded from 'Software Provisioning Manager' website:

https://support.sap.com/en/tools/software-logistics-tools.html 

Regards,
Riccardo

[mamartins]

There is no way to restore HANA databases on MS SQL SERVER.

You need to export the data from the source tables to files (XML, CSV, ...) or using some tool created to do this kind of task, and then import it on MSSQL. Microsoft have some tools (SSIS, Azure Data Factory) to do this.  If it is a SAP product (like Business Suite), you can use the SWPM heterogenous copy method.