Demo presentation text:
Let me show you a demo presentation of the migration tools provided by Ispirer Systems for the Sybase ASE to SAP HANA database migration.
Ispirer Systems provides tools and services for automating databases and applications migration processes for a variety of conversion directions. The list of tools supplied for such a kind of automation is as follows:
• SQLWays Wizard – a GUI tool that is designed to simplify the database conversion process tuning for the SQLWays command-line tool. Works with the source database using the ODBC connection.
• SQLWays Studio – a GUI tool that is designed to simplify the database or application script conversion process tuning for the SQLWays command-line tool. Works with one script at a time.
• SQLWays Commander - a GUI tool that is designed to simplify the database or application scripts conversion process tuning for the SQLWays command-line tool. Works with several scripts at a time.
• Sqlways.exe – a command line tool that can be run in batch mode and can perform the automatic conversion of the database using the ODBC connection or the database and application code provided in scripts.
During this demo I will show you the Sybase ASE to SAP HANA migration using SQLWays Wizard, SQLWays Studio and SQLWays Commander Tools mentioned in the list provided.
On the “Choose a Source Database” page we should specify an ODBC connection for the source database, user name and a password for it.
Click “Next”. On this page we choose SAP HANA as a target, specify the host, port and user name and a password.
Also we should choose a native utility.
On the following page we can see all the objects from the source database: tables, views, stored procedures and triggers.
Let’s choose all these objects for conversion and click next.
On the “Specify DDL and Data Options” page we will specify that our schema name is HanaTest and click next.
On the “Specify Export file Options” page you should specify the directory which serves as an intermediated repository for the whole migration process and stores all the automatically generated files. Then we click next.
Now we will do the conversion without data migration. It will be shown a little bit later. And click next.
Now we can see that the export has already started and is flowing with a success.
All the Sybase ASE to Sap Hana migration process is performed in two stages: Export stage and Import stage. Each of them has its separate logging information.
For the Export process there are sqlways.log files provided, that contain the information about: the objects read from the Sybase ASE database, their number, the number of rows of data and the size of the data per each table extracted, the number of lines of code (LOC) per each business logic object, like views, synonyms, stored procedures, functions, triggers, packages and etc. At the end of the export log file there is summary information about the whole database export.
Similar information but in more readable format is provided in a sqlways_report.html file. Here is a summary table with complete export status and statistics for triggers, stored procedures, views and tables.
For each exported object SQLWays Wizard has generated files with object definition. You can see its commented source and its equivalent for Hana database.
Let’s have a look at the created bat file with command line for native utility HDBSQL to import this object to SAP Hana database.
Let’s start the import process.
As for the import process, SQLWays generates a sqlways_imp.log file for the import into the SAP HANA database that contains the information about what object is being loaded and whether there are any issues during the import process or no.
We can see that our import process is flowing without any issues and soon we’ll see all the objects in the target database. Now it’s finished.
Let’s open SAP HANA Studio and check the converted objects in the SAP HANA database.
I will refresh our schema. You can see all the objects here, all the tables, triggers that have been created, stored procedures. Here you can see the source code and its SAP HANA equivalent. And the same for the other objects. As you can see all the objects have been imported successfully.
You can see that all the tables are empty now. Let’s have a look at data in Sample_header table, Temp VD table and Ven_Doc table.
Now we’ll launch SQLWays Wizard, choose those three tables and export them with data. We will launch SQLWays Wizard again. I will choose only those three tables with data and migrate the data. Let’s create a new folder ExportData, click Next. Would you like to migrate data? – Yes. Since we will be copying our files into SAP HANA server. It’s a Linux server. So we should choose Unix system. And here we should specify post definitions. We will put it into tmp subfolder. On the “Choose a Target Database” page by clicking the button “Advanced Options” we should specify the Bin directory for native utility on the SAP HANA server. It’s the same path.
So we’ve chosen tables, specified the path. Then we click “Next”. We specified the directory for files on the Linux server. And here you can see the export files with data.
Let’s have a look at the export. You can see that for each table SQLWays generates CSV file with data, control file with the path for CC file and a file for import command. It contains a path for the control (ctl) file, and a file for import command. It contains a path to the control file. And SH file, that contains commands for loading table definition into SAP HANA server and for data load. Let’s check all the CSV files.
This CSV file contains data with float type and the other CSV files contain just integer data.
All we need we should copy these files to the Linux server and just run all the SQLWays SH files. I’m opening the Linux server, SAP folder. We paste all the files that we’ve just copied here and run all the SQLWays SH files. Now let’s check SAP HANA Studio and check the data. You can see that all the data has been imported successfully in all the tables. Let’s check the last table. All the data is here.
Now let’s turn to the SQLWays Studio and SQLWays Commander that are designed for database and application scripts conversion. Let’s choose Sybase Adapter Server Enterprise as a source and SAP Hana as a target and click run.
At the bottom of the tool you can see conversion log which shows whether there are any errors during script conversion.
Let’s open SQLWays Commander. There are also two panes which give you opportunity to specify a file, or files or the whole directory for conversion. Let’s specify the source and target directions. Here you also should specify a target directory to which the converted files will be put. Then we click “Run” and at the bottom you’ll see a generated log with information about the conversion issues if there are any.
That’s all that I wanted to tell you about Sybase ASE to SAP Hana migration using SQLWays.
The information about the peculiarities of Sybase ASE to SAP HANA migration and other tools that Ispirer Systems provides for database migration support will be described in our next demos or can be found on our website.
I hope this demo was useful. Thank you!