on 05-31-2013 6:15 AM
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
plz refer this link is useful
Regards:
satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.