cancel
Showing results for 
Search instead for 
Did you mean: 

Best way to Migrate from MSSQL to HANA

Former Member
0 Kudos

HI,

We are presently using MSSQL Server 2008.

We would like to migrate to HANA now. We have around 40 tables and huge data in SQL Server.

What is the best way(other than BODS) to move our sql schema with all data to HANA?

Thanks & Regards

Prashanth Polasa

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos
Former Member
0 Kudos

Hi Satish,

Thanks for your quick reply.

The link which you have mentioned is using BODS 4.1 to transfer the data.

As we are from DotNet platform, is there any other option than BODS?

former_member184768
Active Contributor
0 Kudos

Hi Prashanth,

With SAP HANA you will have to use any of the ETL tool like BODS, SLT or any third party ETL tool like Informatica which can connect to HANA over JDBC / ODBC connectivity and perform data insert operations.

You can also generate CSV file dumps for your 40 tables and load them to HANA using flat file upload interfaces.

Since HANA cannot connect directly to SQL server, you will have to use the ETL tool.

If possible, you can also create your custom application in .NET (Dot NET) which can connect to HANA over ODBC (or JDBC) and perform the inserts reading data from the MSSQL tables.

Regards,

Ravi

Former Member

Hi Ravindra,

Thanks for your help.

As we don't have BODS or any other third party tool, you are intended to say we have to move all SQL schema and data manually?

If we have to migrate manually, could you please tell me how to move stored procedures that are in SQL server to HANA.

One more question to ask: Can we use The script (which is generated from SQL server)  to create tables/stored procedures in HANA?

Regards

Prashanth Polasa

Answers (0)