Is there any way to migrate a SAP HANA database from HANA Studio to an SQL Server instance?

[former_member613954]

I'm making some speed and performance benchmarks with a SAP HANA instance of ours, testing multiple queries across the entire database in parallel (that includes SAP B1 objects and also custom addon objects)

For testing purposes I would like to repeat these same benchmark tests with another SAP instance, but using an SQL Server instance. Besides SAP B1 client, I don't know if there is any other way to make a quick migration of an entire database using the "Export" functionality from HANA Studio, and then importing it to our SQL Server instance via the Import feature, or by using any other means. What are our available options to migrate an entire catalog from HANA Studio to SQL Server (by using SQL Management studio, or any other SQL database management software)?

[Johan_H]

Hi Sergio,

If with "SAP B1", you mean SAP Business One, it is unlikely that there is a tool to convert a HANA database to MS SQL, and have it actually work. But there are data migration tools, with which you could populate a SAP Business one MS SQL test database.

Please add the SAP Business One tag. Perhaps there are people who have done something like this already.

Regards,

Johan

[Javier-Martin]

Hi Sergio,

Regarding the tag you have used called "SAP Advanced SQL Migration" I have to say that this tool would be able to partially help when doing what you want but in the other way around, that is from MSSQL to Hana. Let' see if you get some help from other colleagues.

Good luck.

Javier Martin.