How to Convert SQL from MS SQL Server to SAP HANA - new version UI enabled!

In this blog I'll like to point you to a tool that has been recently released in SDN for converting SQL language from MS SQL Server to SAP HANA™.

The Query Migration Tool for Microsoft SQL Server to SAP HANA is a semi-automatic tool that helps convert most of the data-definition language (DDL) and data-manipulation language (DML).

It will help you to convert structured query language (SQL) in the Microsoft SQL Server database (using T-SQL grammar) to SQL that can be used in the SAP HANA™ database (using ANSI-SQL grammar).

After the conversion, you must check whether the converted version is correct according to your needs. 

This tool supports most of the official T-SQL grammar, and some well-known and widely-used undocumented feature. For more information about the official T-SQL grammar, see the MSDN Library. 

If SAP HANA does not support certain SQL, this tool will do the following: 

• Find equivalents in the SAP HANA database and convert the SQL.

• Delete the SQL in the input file and display relevant comments in the output file.

• Leave the SQL in the input file as it is, for example, the WITH statement.

Download links:

• Query Migration Tool for Microsoft SQL Server to SAP HANA  (new version UI enabled!!)
• How-to Guide (please check it before running the tool).

In order to be up to date with the SQL language supported by SAP HANA please check the following links:

• SAP HANA Appliance Software - Help Portal
• SAP HANA Database - SQL Reference Manual
• SAP HANA SQLScript Reference

Note:

If you encounter any issue when using the SQL converter, post the issue to the SAP Community Network athttp://scn.sap.com/community/business-one for general topics or at http://scn.sap.com/community/business-one/system-administrationfor system-administration topics. Please don't post them here as this is not in a discussion format easy to follow up.

We hope this tool will help you.