Recommendations / Guidelines for Smooth Migration from SQL to HANA.

[rahuljain257]

Hello Friends,

Is there any specific guide lines available for SQL, Oracle Query syntax that if we use such syntax then the migration will be lot simpler and necessary re-work can be handled.

Regards

Rahul Jain

[Javier-Martin · Accepted solution]

Hi Rahul,

As far as I know there are no documents with specific guidelines for conversion from Oracle SQL (PL/SQL) to Hana SQL (SQLScript), in some parts both are ANSI and syntax is very similar, but in others parts/features and ANSI extensions they are very different. This is something we take care about in SAP Advanced SQL Migration tool and we aim to do as much automatic conversion as possible.

Regards.

Javier.