Human Capital Management Blogs by SAP
Get insider info on HCM solutions for core HR and payroll, time and attendance, talent management, employee experience management, and more in this SAP blog.
cancel
Showing results for 
Search instead for 
Did you mean: 
yogananda
Product and Topic Expert
Product and Topic Expert

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 VendorSource DB VersionsTarget Database*
Oracle9, 10, 11, 12SAP HANA
Microsoft SQL Server2000s – 2017SAP HANA
IBM DB2 UDB for LUW9.x *SAP HANA
IBM Netezza SAP HANA


* Refer User Guide Documentation for more information.

If you are interested in any other source/target database combination 

please contact: advanced_sql_migration@sap.com


Github Screenshots : https://github.com/sap-tutorials/Tutorials/tree/master/tutorials/advanced-sql-migration-tool-ora-han...



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.

Convert Oracle-to-SAP HANA with Advanced SQL Migration Tool

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

 

I hope this information was helpful and interesting, if you have any questions, just drop a comment below and I can respond to any questions you may have about from this blog!!