As I would like to think now and again it is hard to clarify in a fast manner how something functions in any event, having great and clear clarifications, we as a whole realize that a solitary picture merits 1,000 words…

Showing every one of the capacities given by SAP Brim Solutions Advanced SQL Migration device in a short demo is difficult, however basically we have made a video exhibiting how this movement apparatus can change an Oracle pattern over to SAP Hana. The video shows too how the very application that was neutralizing Oracle is likewise functioning admirably against SAP Hana in the wake of relocating the diagram, SQL Objects and information, giving a similar conduct it had in Oracle.

A few insights concerning the application and information model:

The application is a 2-level (client-server) java application dealing with a distributions information base, including substances like creators, titles, distributers, orders… and so forth (In the event that you have some Sybase foundation the information model is coming from the renowned "pubs2" SAP ASE data set)
The information model comprise of 8 tables, a few arrangements, equivalent words and some SQL objects like put away methods, capacities and bundles containing around 2100 lines of Oracle PL/SQL code in including special case taking care of, %ROWTYPEs, (REF)Cursors, FOR-circles, cursors, worked in capacities calls, subqueries, exchanges… and so forth
The video shows the accompanying advances:

First the way in which the application neutralizes Oracle, commenting how Oracle exemption dealing with is utilized to deal with some client blunder conditions.
Then, at that point, SAP Advanced SQL Migration is executed to separate information model and SQL objects from Oracle and converts them to SAP Hana SQLScript vernacular.
The changed over code given by the relocation instrument is executed against SAP Hana utilizing shell scripts naturally created.
Information from Oracle tables is duplicated to SAP Hana data set utilizing SAP Hana Smart Data Access (SDA).
The java client application is disengaged from Oracle and associated with SAP Hana without any progressions whatsoever, it is shown the way that the application works and handles the blunder conditions similarly Oracle was doing previously.