Demo presentation text:
This is the demo about the tools provided by Ispirer Systems for database or scripts migration. This demo is particularly devoted to the database conversion from Oracle to HPE NonStop.
For this conversion we will use the following tools:
• Ispirer Migration and Modernization Engine – a command line tool that can be run in batch mode and can perform the automatic conversion of a database or database and application code contained in scripts.
• Ispirer SQLWays Wizard – a GUI tool designed particularly for the database migration. It works with a source database using the ODBC connection.
• Ispirer Migration Studio – a GUI tool oriented specifically to the conversion of a separate application or database script. It works with one script at a time.
• Ispirer Migration Commander – a GUI tool designed for the conversion of multiple files containing application or database code. It works with several scripts at a time.
For the purposes of this demo, we have prepared 4 objects:
1) a table called !STUDENTS which consists of 8 columns;
2) a package called UNIVERSITY which includes TYPE IS RECORD, procedures and a function.
This package works with the table called STUDENTS.
It gets information on the tables’ column types and performs operations with the table using the DML statements, such as INSERT, UPDATE and DELETE.
3) CHECK_STUDENTS_COUNT_IN_GROUP procedure works with the table called STUDENTS, gets information about number of students in a specific group and return this count as OUT parameter.
4) GENERATE_EMAIL function generates and outputs the result containing a student’s e-mail on the base of the values passed to the function parameters.
Let us convert the objects from the Oracle database to HPE NonStop with the help of the Ispirer SQLWays Wizard – we can see it on the screen.
After launching the SQLWays Wizard, on the Welcome page, we have to specify the license information for this product and a project directory. In this directory will be stored the set of files required for the project.
These files contain information about the objects selected for the conversion and the options that we selected while tuning up the migration process.
We can go to the next page.
On a «Choose a source database» page, we need to specify a user or system DSN name of the ODBC connection to our Oracle database.
Also we need to specify the user name and the password.
On a «Choose a target database» page, we now need to identify the target database NonStop from the list of the supported databases. Other credentials are also necessary (like host name, database, user name and password), so the NonStop database supports the definitions and data load using native utilities of this database.
And we go next.
On a «Specify database objects» page we can see all the objects of the source database specified in a tree view. We can select the objects for the conversion from Oracle to NonStop. In the target pane, we can see the tree view of the selected objects.
After that, we can specify different options, which help you to customize Oracle to NonStop conversion. For example, the option “Omit schema names in SQL scripts”, which controls schema name conversion. We choose “Yes”, in order to remove all schema names from the conversion from Oracle to HPE NonStop.
On a «Specify export file options» page we identify the «Export directory» which will serve as an intermediate repository for the whole migration process.
On a «Specify import options» page we need to specify BIN directory to native utility of HPE NonStop. RMXCI utility is used for making import into NonStop database.
On a “Migration Status” page, we can launch the conversion by clicking on the button “Start Conversion”. Now we can see the migration process.
In order to review the conversion results we press the button “View Export”.
Let’s review the generated files.
Business logic was converted to NonStop Stored Java Procedures.
So, JAVA and SQL files were generated.
The File called Check_students_count_in_group.java with the same named class generated from the Oracle procedure. And appropriate CREATE PROCEDURE in Check_students_count_in_group.sql file was created.
The file called Generate_email.java with Generate_email class generated from the Oracle function.
And appropriate CREATE PROCEDURE in Generate_email.sql file was created.
For STUDENTS table STUDENTS_DDL.SQL file with the table DDL and STUDENTS.SQL file with data INSERTS were created.
The file called University.java with University class generated from the Oracle package. And appropriate CREATE PROCEDURES in University.sql file were created.
Now we need to compile JAR-file from the created java classes and put it to NonStop external directory.
And after that we can run the import process via Ispirer SQLWays Wizard which will load all the objects in HPE NonStop.
Let’s check the results.
If we run some procedures in both databases, we will get the same results.
You can notice that the count of rows in STUDENTS table is the same in both Oracle and NonStop databases.
Business logic converted properly.
Now let’s move on to the Ispirer Migration Commander. This tool allows converting multiple scripts at a time. Let’s take some scripts from our source database and convert them from Oracle to NonStop.
We can specify a file, multiple files, or the entire directory for the conversion.
We also specify the source Oracle and the target NonStop database and run the conversion.
Now let’s review the results of the conversion.
We can compare both the source and its equivalent on the target pane.
Let's look now at the Ispirer Migration Studio. It works with one script at the same time.
To accomplish the conversion let’s open a script with Oracle package and launch the conversion.
As soon as the conversion is done we can compare both the source and the target code side-by-side.
It is just a review of the tools and the features that they support, so if you need additional information please contact us, and we will be glad to assist you in your migration projects.
Thank you very much for your attention. Bye.