Skip to Content
0

Converting database SQL to Hana.

Dec 07, 2016 at 04:18 PM

56

avatar image

Helo!

I have a question about converting a SQL database to Hana. Is there any way to perform this process by a software? I have verified that there is SAP "Migration Tools", but I can not find the file in the installation folder and I dont find the download link.

Does anyone have the download link? I did not find this tool in the download center. Is there any other procedure that can be performed to make this migration more streamlined?

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sergio Guerrero Dec 14, 2016 at 05:17 PM
0

Alfredo,

I do not think there is a tool that would do this for several reasons:

1) the persistance layer is going to be different - HANA uses (for the most part) columnar base tables

2) the SQLScript language used on HANA is derived from ANSI SQL, however, there may be slight syntax differences

3) stored procedures, views, tables, etc... can be created (best practices) as design-time objects rather than catalog objects as it is done in other DBs - HANA also has catalog objects but it is not Best Practices to use those.

4) Security on its own is a different arena - depending on which version you go to.. your users could be DB users (on XS Classic Architecture) or or as a part of an Identity Provider (XS Advanced architecture)

5) Data migration

there are many many many other things probably which I am not stating here but that is why I do not think there is a software tool / program that does this conversion. Please see your preferred SAP partner, SAP itself or other ways to facilitate this for you.

If you are evaluating SAP HANA, you could also try the express edition for a non-prod environment to see if this is something you really want to get to. Good luck on the research .. hope this helps... maybe others can provide other suggestions.

Share
10 |10000 characters needed characters left characters exceeded