SAP Commissions – SAP Advanced SQL Migration

This article is intended for anyone who will be using the SAP Advanced SQL Migration tool. This tool is intended to be used by SQL specialists who are familiar with the SQL language.

Migration tool users will need to be skilled in the syntax and semantics of the SQL dialects of both the source DBMS and target DBMS of the migration. In particular, knowledge is required of server-side SQL constructs (e.g. stored procedures) and the corresponding SQL flavours (e.g. Oracle PL/SQL, SAP Hana SQLScript)

SAP Advanced SQL Migration is an SAP-provided tool to assist with migrating custom (non-SAP)
applications, especially those using server-side SQL stored procedures, functions, etc., from a non-SAP database to an SAP database

This migration tool aims to make migration projects more manageable by assisting consultants/developers with:
• Automatically performing as much of the ‘simple’ conversion work as possible.
• Providing insight in the areas where additional manual intervention is required.

Before using SAP Advanced SQL Migration, ensure that all stakeholders are aware of the legal
requirements and restrictions on the use of the migration tool, such as the terms of use.
In addition, ensure that the owner of intellectual property rights to the application being migrated, has authorized the migration being performed. When the migration tool connects directly to a non-SAP source DBMS system, ensure that this is compliant with the applicable license terms governing that DBMS system.

➜ Download

➜ SUPPORTED SOURCE & TARGET DATABASES

Source Database Vendor Source DB Versions Target Database*
Oracle 9, 10, 11, 12 SAP HANA
Microsoft SQL Server 2000s – 2017 SAP HANA
IBM DB2 UDB for LUW 9.x * SAP HANA
IBM Netezza SAP HANA

* Refer User Guide Documentation for more information in your downloaded folder

If you are interested in any other source/target database combination please contact: advanced_sql_migration@sap.com


Prerequisites for Installation

  1. Perl and Perl libraries
  2. Cygwin
  3. Java version JRE8
  4. JDBC Driver file (ojdbc.jar for Oracle, sqljdbc.jar for Microsoft SQL Server, db2jcc4.jar for IBM DB2)

This video shows a live-recorded demo of migrating a custom (non-SAP) database application from Oracle to SAP HANA. The migration is performed using the SAP Advanced SQL Migration tool, which converts the Oracle SQL dialect to the SAP HANA SQL dialect. In this demo, the conversion of schema and PL/SQL objects (procedures, functions, packages) is 100% automatic and correct.

With all the advancements found in the Advanced SQL Migration tool, it is now simple to get such migration. It happens usually with a click of the mouse. The idea is to carry out multiple processes bundled into a single task. But the beauty of the tool is also the possibility of selecting particular database type to be migrated.

References

➜ https://community.sap.com/topics/advanced-sql-migration