SAP Advanced SQL Migration. Oracle to Hana database migration demo
In my opinion sometimes it is difficult to explain in a quick way how something works even having good and clear explanations, we all know that a single picture is worth a thousand words…
Showing all the capabilities provided by SAP Advanced SQL Migration tool in a short demo is not easy, but at least we have created a video demonstrating how this migration tool is able to convert an Oracle schema to SAP Hana. The video illustrates as well how the same application that was working against Oracle is also working well against SAP Hana after migrating the schema, SQL Objects and data, providing the same behavior it had in Oracle.
Some details about the application and data model:
- The application is a 2-tier (client-server) java application managing a publications database, including entities like authors, titles, publishers, orders… etc. (If you have some Sybase background the data model is coming from the famous “pubs2” SAP ASE database)
- The data model consist of 8 tables, some sequences, synonyms and some SQL objects like stored procedures, functions and packages containing around 2100 lines of Oracle PL/SQL code in including exception handling, %ROWTYPEs, (REF)Cursors, FOR-loops, cursors, built-in functions calls, subqueries, transactions…etc.
The video shows the following steps:
- First how the application works against Oracle, remarking how Oracle exception handling is used to handle some user error conditions.
- Then, SAP Advanced SQL Migration is executed to extract data model and SQL objects from Oracle and converts them to SAP Hana SQLScript dialect.
- The converted code provided by the migration tool is executed against SAP Hana using shell scripts automatically generated.
- Data from Oracle tables is copied to SAP Hana database using SAP Hana Smart Data Access (SDA).
- The java client application is disconnected from Oracle and connected to SAP Hana with no changes at all, it is shown how the application works and handles the error conditions in the same way Oracle was doing before.
Now watch the video here an enjoy.
Note: video is not edited, only fast-forward is appearing in a couple of long run parts.